FAQ

PostgreSQL > pgsql-performance > March 2008

Search Discussions

72 discussions - 538 posts

  • count(*) tooks much time... but with the where clause we can make this to use indexing,... what where clause we can use?? Am using postgres 7.4 in Debian OS with 1 GB RAM, am having a table with ...
    Sathiya psqlSathiya psql
    Mar 6, 2008 at 5:43 am
    Mar 18, 2008 at 3:42 pm
  • I am going to embarkon building a music library using apache, postgresql and php. What is the best way to store the music files? Which file type should I use?
    RichRich
    Mar 16, 2008 at 6:12 am
    Mar 19, 2008 at 1:41 pm
  • Is there any article describing the migration database from postgresql 7.4to 8.1
    Sathiya psqlSathiya psql
    Mar 12, 2008 at 5:27 am
    Mar 12, 2008 at 2:46 pm
  • Hi all I'm encountering an odd issue with a bulk import query using PostgreSQL 8.3. After a 400,000 row import into a just-truncated table `booking', a sequential scan run on the table in the same ...
    Craig RingerCraig Ringer
    Mar 10, 2008 at 9:56 am
    Mar 11, 2008 at 9:58 am
  • Hello, i have problem with following table... create table dataaction ( id INT4 not null, log text, primary key (id) ); It is the table for storing results of long running jobs. The log attribute ...
    Pavel RotekPavel Rotek
    Mar 7, 2008 at 8:35 am
    Mar 7, 2008 at 3:03 pm
  • (Declaration of interest: I'm researching for a publication on OLTP system design) I have a question about file writes, particularly on POSIX. This arose while considering the extent to which cache ...
    James MansionJames Mansion
    Mar 31, 2008 at 7:49 pm
    Apr 17, 2008 at 6:19 pm
  • Hello, I need to install a new server for postgresql 8.3. It will run two databases, web server and some background programs. We already have a server but it is becoming slow and we would like to ...
    Laszlo NagyLaszlo Nagy
    Mar 28, 2008 at 9:22 am
    Mar 31, 2008 at 3:15 am
  • Dear Friends, I have a table with 32 lakh record in it. Table size is nearly 700 MB, and my machine had a 1 GB + 256 MB RAM, i had created the table space in RAM, and then created this table in this ...
    Sathiya psqlSathiya psql
    Mar 25, 2008 at 8:35 am
    Mar 27, 2008 at 5:33 pm
  • I have a big PG server dedicated to serve only SELECT queries. The database is updated permanently using Slony. The server has 8 Xeon cores running at 3Ghz, 24GB or RAM and the following disk arrays: ...
    Laurent RaufasteLaurent Raufaste
    Mar 19, 2008 at 11:18 am
    Mar 21, 2008 at 1:54 pm
  • I am moving our small business application database application supporting a 24/7 animal hospital to use 8.0.15 from 7.4.19 (it will not support 8.1, 8.2. or 8.3). Now, we can choose a new a disc ...
    Steve PoeSteve Poe
    Mar 2, 2008 at 7:37 am
    Mar 3, 2008 at 7:45 pm
  • Ok, finally am changing my question. Do get quick response from postgresql what is the maximum number of records i can have in a table in postgresql 8.1 ???
    Sathiya psqlSathiya psql
    Mar 25, 2008 at 11:42 am
    Mar 26, 2008 at 12:21 pm
  • I just found out that my company is planning on migrating my databases from our current ISCSI storage solution to NetApps connected via NFS. I knew about the NetApp migration, but always assumed (and ...
    Chris HooverChris Hoover
    Mar 20, 2008 at 7:38 pm
    Mar 25, 2008 at 1:33 pm
  • Hi! I'm testing an update on 66k rows on Postgresql, and it seems something is not right here. My server is a Quad-Xeon 3.2 Ghz with 2 GB RAM and a RAID 1 running FreeBSD 6.3 and PgSQL 8.3. My ...
    Miguel ArrozMiguel Arroz
    Mar 10, 2008 at 2:28 am
    Mar 11, 2008 at 4:14 am
  • Hello We hace a Quad Xeon server, with 8GO of ram, sata II 750Go An postgresql database, of 10 Go I have several treatment every 2 minutes who select, insert, update thousand of data in a table. It ...
    DforumsDforums
    Mar 4, 2008 at 8:55 pm
    Mar 5, 2008 at 8:25 am
  • I've got a new server and am myself new to tuning postgres. Server is an 8 core Xeon 2.33GHz, 8GB RAM, RAID 10 on a 3ware 9550SX-4LP w/ BBU. It's serving as the DB for a fairly write intensive (maybe ...
    Alan bryanAlan bryan
    Mar 3, 2008 at 11:39 pm
    Mar 4, 2008 at 4:25 pm
  • The owners of the animal hospital where I work at want to consider live/hot backups through out the day so we're less likely to lose a whole day of transaction. We use Postgresql 8.0.15. We do 3AM ...
    Steve PoeSteve Poe
    Mar 24, 2008 at 8:23 pm
    Mar 25, 2008 at 4:50 am
  • Hi all, I have been searching for the best way to run maintenance scripts which does a vacuum, analyze and deletes some old data. Whenever the maintenance script runs - mainly the pg_maintenance ...
    Vinubalaji GopalVinubalaji Gopal
    Mar 15, 2008 at 12:25 am
    Mar 16, 2008 at 6:11 pm
  • Below I have two almost identical queries. Strangely enough the one that uses the index is slower ??? explain analyze select uid from user_profile where lower(firstname)='angie' and extract(year from ...
    Dave CramerDave Cramer
    Mar 6, 2008 at 12:27 am
    Mar 8, 2008 at 1:20 am
  • Hi all, maybe it’s a naive question but I was wondering if there is any difference, from a performance point of view, between a view and a function performing the same task, something like: CREATE ...
    Giorgio ValotiGiorgio Valoti
    Mar 22, 2008 at 2:01 pm
    Apr 11, 2008 at 7:24 am
  • Hi I have a table with around 10 million entries The webpage rendered hits at most 200 records which are distributed well in the 10m with an average of 2 "references" pr. entry. Is there anyway to ...
    Jesper KroghJesper Krogh
    Mar 27, 2008 at 3:35 pm
    Mar 27, 2008 at 5:54 pm
  • I'm not a DBA....but I play one at my office. I also have a hand in system administration, development and stairwell sweeping. Small shop...many hats per person. We have a postgresql (v8.2.X) ...
    P princeP prince
    Mar 26, 2008 at 7:48 pm
    Mar 27, 2008 at 3:13 pm
  • Hello, we have several indexes such as: create index foo1 on bla (a); create index foo2 on bla (b); create index foo3 on bla (a,b); They are all used often by frequently used queries (according to ...
    Marinos YannikosMarinos Yannikos
    Mar 26, 2008 at 2:51 pm
    Mar 26, 2008 at 4:21 pm
  • Hi, I'm uning postgres 8.1 at P4 2.8GHz with 2GB RAM. (web server + database on the same server) Please, how long takes your connectiong to postgres? $starttimer=time()+microtime(); $dbconn = ...
    FireroxFirerox
    Mar 24, 2008 at 7:40 am
    Mar 25, 2008 at 4:20 am
  • Hi folks, We are running Postgres 8.2.5. I have 3 tables, call them A, B, and C Table A houses info on all emails that have ever been created for the purpose of being delivered to our end customers. ...
    Mark StebenMark Steben
    Mar 18, 2008 at 9:07 pm
    Mar 19, 2008 at 1:56 pm
  • A number of weeks ago, I had posted a request for help regarding join estimates in pg 8.2.6. In moderately complex to very complex ad hoc queries in our system, we were consistently having the system ...
    Chris KratzChris Kratz
    Mar 18, 2008 at 3:42 pm
    Mar 19, 2008 at 12:01 am
  • Dear Friends, I have a table with 50 lakhs records, the table has more then 10 fields, i have primary key, i have select query with count(*) without any condition, it takes 17 seconds. I have another ...
    SPMLINGAMSPMLINGAM
    Mar 5, 2008 at 10:27 am
    Mar 5, 2008 at 4:02 pm
  • hi all, I want this mail to be continued about summary of performance tuning tools... or other postgres related tools.. I ll start with saying there is a tool SCHEMASPY ( i got to know about this ...
    Sathiya psqlSathiya psql
    Mar 17, 2008 at 12:08 pm
    Mar 18, 2008 at 2:56 am
  • It often happens that a particular pieces of information is non-null for a small minority of cases. A superficially different manifestation of this is when two pieces of information are identical in ...
    Kynn JonesKynn Jones
    Mar 14, 2008 at 6:05 pm
    Mar 14, 2008 at 8:30 pm
  • Hello, we plan to buy a dedicated server to host our database. Here is the proposal I was given (with a second identical server fro backup using log shipping): ========================= IBM X3650 ...
    Pascal CohenPascal Cohen
    Mar 12, 2008 at 6:58 pm
    Mar 14, 2008 at 7:43 pm
  • Hi! As part of a data warehousing project, I need to pre-process data downloaded from an external source, in the form of several large flat files. This preprocessing entails checking the validity of ...
    Kynn JonesKynn Jones
    Mar 8, 2008 at 5:31 pm
    Mar 11, 2008 at 3:57 pm
  • Hi We are thinking of running a PostgreSQL instance on a virtual host under Xen. Any thoughts for/against running PostgreSQL on a virtual host would be much appreciated. -- Regards Theo
    Theo KramerTheo Kramer
    Mar 4, 2008 at 4:12 pm
    Mar 5, 2008 at 3:03 pm
  • Is there any tool to draw ER diagram from SQL schema file... no other groups are replying.....
    Sathiya psqlSathiya psql
    Mar 13, 2008 at 1:24 pm
    Mar 14, 2008 at 11:35 am
  • Hi chaps, I'm looking at switching out the perc5i (lsi megaraid) cards from our Dell 2950s for something else as they're crap at raid 10. Thing is I'm not entirely sure where to start, we're using 6 ...
    Glyn AstillGlyn Astill
    Mar 13, 2008 at 12:35 pm
    Mar 14, 2008 at 5:53 am
  • hi, is there any generalized format for the output for the output of the explain command ?. If so please send that generalized format to me. otherwise tell me how to parse the output of explain ...
    RaviRam KolipakaRaviRam Kolipaka
    Mar 6, 2008 at 6:10 am
    Mar 7, 2008 at 12:59 pm
  • i had a table with 50 lakh record... it has a column called oid ( obviously all the tables will have this ), but while doing any operation it is getting slow because of the number of records... if i ...
    Sathiya psqlSathiya psql
    Mar 6, 2008 at 7:02 am
    Mar 6, 2008 at 4:28 pm
  • Hello Everyone, I had posted an issue previously that we've been unable to resolve. An early mis-estimation in one or more subqueries causes the remainder of the query to choose nested loops instead ...
    Chris KratzChris Kratz
    Mar 4, 2008 at 2:49 pm
    Mar 4, 2008 at 6:42 pm
  • Subject about says it all. Should I be more concerned about checkpoints happening 'frequently' or lasting 'longer'? In other words, is it ok to checkpoint say, every 5 minutes, if it only last a ...
    Douglas J HunleyDouglas J Hunley
    Mar 3, 2008 at 2:25 pm
    Mar 3, 2008 at 5:06 pm
  • Hi I've been wondering about postgresql's handling of repeated subqueries in statements for a while, and thought I'd ask here. If the exact same subquery appears in multiple places in a complex ...
    Craig RingerCraig Ringer
    Mar 13, 2008 at 3:38 am
    Mar 13, 2008 at 2:06 pm
  • Hello --------------------------- Postgresql version: 8.1.10 4GB RAM 2x HP 72GB 10K SAS RAID1/smartarray --------------------------- I have a colleague that is having som performance problems from ...
    Rafael MartinezRafael Martinez
    Mar 3, 2008 at 3:18 pm
    Mar 4, 2008 at 11:57 am
  • Hey all, I had posted sometime back asking for the best way to perform vacuum with a lower priority - I did tune it up to a lower priority and still noticed that the other database queries are ...
    Vinubalaji GopalVinubalaji Gopal
    Mar 26, 2008 at 7:50 pm
    Mar 28, 2008 at 6:29 am
  • Hi friends, I am using postgresql 8.1, I have shared_buffers = 50000, now i execute the query, it takes 18 seconds to do sequential scan, when i reduced to 5000, it takes one 10 seconds, Why. Can ...
    Petchimuthu lingamPetchimuthu lingam
    Mar 24, 2008 at 9:28 am
    Mar 25, 2008 at 12:24 pm
  • i am using postgresql 8.1.8, Following configurations: shared_buffers = 5000 work_mem = 65536 maintenance_work_mem = 65536 effective_cache_size = 16000 random_page_cost = 0.1 The cpu is waiting ...
    Petchimuthu lingamPetchimuthu lingam
    Mar 24, 2008 at 1:06 pm
    Mar 25, 2008 at 1:13 am
  • Hi All, I want some clarification in the following, In a database which we are having we have nearly 100 tables, and in 75% of the tables we have 6 columns ( INT ) as standard columns. What is ...
    Sathiya psqlSathiya psql
    Mar 22, 2008 at 4:10 am
    Mar 22, 2008 at 9:08 am
  • On a database (PostgreSQL 8.2.4 on 64-bit Linux 2.6.18 on 8 AMD Opterons) that is under high load, I observe the following: - About 200 database sessions concurrently issue queries, most of them ...
    Albe LaurenzAlbe Laurenz
    Mar 14, 2008 at 1:50 pm
    Mar 17, 2008 at 10:36 am
  • how to find trigger names in my database ? using psql 7.4 the following query shows system triggers, i want only to list the triggers created by me select relname, tgname, tgtype, proname, prosrc, ...
    Sathiya psqlSathiya psql
    Mar 11, 2008 at 1:38 pm
    Mar 12, 2008 at 5:17 am
  • I have one table with 30 fields, i have more then 60 million records, if i use more no of indexes will it affect the insertion performance? and select performance? Shall i have more then one partial ...
    Petchimuthu lingamPetchimuthu lingam
    Mar 11, 2008 at 12:28 pm
    Mar 11, 2008 at 4:05 pm
  • I've came across this issue while writing report-like query for 2 not very large tables. I've tried several methods to resolve this one (see below). But now I'm really stuck... PostgreSQL 8.3, ...
    Vlad ArkhipovVlad Arkhipov
    Mar 7, 2008 at 5:52 am
    Mar 11, 2008 at 1:52 am
  • Hi all, I'm running the following query to match a supplied text string to an actual place name which is recorded in a table with extra info like coordinates, etc. SELECT ...
    B wraggB wragg
    Mar 7, 2008 at 4:31 am
    Mar 7, 2008 at 8:44 am
  • Hello, I'm sorry if this has been discussed before, I couldn't find a discussion about this problem. I've done the same query on a 8.2.5 database. The first one is prepared first and the other is ...
    Martin KjeldsenMartin Kjeldsen
    Mar 31, 2008 at 11:17 am
    Mar 31, 2008 at 11:59 am
  • I have a query which is prepare s_18 as select uid from user_profile where name like $1::varchar and isactive=$2 order by name asc limit 250; explain analyze execute s_18 ('atxchery%','t'); QUERY ...
    Dave CramerDave Cramer
    Mar 27, 2008 at 7:14 pm
    Mar 28, 2008 at 2:54 pm
Mar 2008
12
Group Navigation
period‹ prev | Mar 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions72
posts538
users123
websitepostgresql.org
irc#postgresql

123 users for March 2008

Sathiya psql: 33 posts Tom Lane: 31 posts Craig Ringer: 28 posts Greg Smith: 28 posts Scott Marlowe: 21 posts Bill Moran: 17 posts Joshua D. Drake: 15 posts Craig James: 14 posts SPMLINGAM: 14 posts Dave Cramer: 13 posts Bruce Momjian: 12 posts Justin Graf: 12 posts Matthew: 11 posts Andreas Kretschmer: 10 posts Alvaro Herrera: 8 posts Heikki Linnakangas: 8 posts James Mansion: 8 posts Mark Mielke: 7 posts Pavel Rotek: 7 posts PFC: 7 posts
show more
Archives