FAQ

Search Discussions

42 discussions - 432 posts

  • Hi, We're currently having a problem with queries on a medium sized table. This table is 22GB in size (via select pg_size_pretty(pg_relation_size('table'));). It has 7 indexes, which bring the total ...
    Henk de witHenk de wit
    Aug 26, 2008 at 4:44 pm
    Sep 15, 2008 at 2:26 pm
  • Hello list, I have a server with a direct attached storage containing 4 15k SAS drives and 6 standard SATA drives. The server is a quad core xeon with 16GB ram. Both server and DAS has dual PERC/6E ...
    HenrikHenrik
    Aug 8, 2008 at 2:44 pm
    Aug 17, 2008 at 11:18 am
  • Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file systems, hardware and software raid with a little bit of volume management: ...
    Mark WongMark Wong
    Aug 5, 2008 at 4:54 am
    Dec 9, 2008 at 2:35 pm
  • Hi, I run this query: select max(a."user"), b.category, count(1) from result a, domain_categories b where a."domain" = b."domain" group by b.category; the table result contains all websites a user ...
    Moritz OnkenMoritz Onken
    Aug 18, 2008 at 2:09 pm
    Aug 22, 2008 at 5:57 pm
  • Hi, I use Postgresql 8.3.1-1 to store a lot of data coming from a large amount of sensors. In order to have good performances on querying by timestamp on each sensor, I partitionned my measures table ...
    Loic PetitLoic Petit
    Aug 23, 2008 at 1:41 am
    Aug 26, 2008 at 3:30 pm
  • I have a table named table_Users: CREATE TABLE table_Users ( UserID character(40) NOT NULL default '', Username varchar(256) NOT NULL default '', Email varchar(256) NOT NULL default '' etc... ); The ...
    JayJay
    Aug 11, 2008 at 8:04 am
    Aug 12, 2008 at 6:52 pm
  • Hi I am working on a table which stores up to 125K rows per second and I find that the inserts are a little bit slow. The insert is in reality a COPY of a chunk of rows, up to 125K. A COPY og 25K ...
    Thomas FinneidThomas Finneid
    Aug 31, 2008 at 1:32 pm
    Sep 5, 2008 at 8:09 am
  • My company finally has the means to install a new database server for replication. I have Googled and found a lot of sparse information out there regarding replication systems for PostgreSQL and a ...
    Dan HarrisDan Harris
    Aug 21, 2008 at 6:26 pm
    Aug 23, 2008 at 7:40 am
  • This query is run on a test system just after a backup of the database has been restored and it does exactly what I expect it to do EXPLAIN ANALYZE SELECT foos.* FROM foos INNER JOIN bars ON foos.id ...
    Joshua ShanksJoshua Shanks
    Aug 6, 2008 at 9:35 pm
    Aug 8, 2008 at 2:51 pm
  • Folks, In a fresh Pg8.3.3 box, we created a 3-stripe RAID0 array. The write speed is about 180MB/s, as shown by dd : # dd if=/dev/zero of=/postgres/base/teste2 bs=1024 count=5000000 5000000+0 records ...
    André VolpatoAndré Volpato
    Aug 20, 2008 at 7:56 pm
    Aug 29, 2008 at 2:29 am
  • Hi, Can anyone suggest the performance tips for PostgreSQL using Hibernate. One of the queries: - PostgreSQL has INDEX concept and Hibernate also has Column INDEXes. Which is better among them? or ...
    Kranti K K Parisa™Kranti K K Parisa™
    Aug 20, 2008 at 12:26 pm
    Aug 22, 2008 at 5:52 am
  • I'm currently trying to find out what the best configuration is for our new database server. It will server a database of about 80 GB and growing fast. The new machine has plenty of memory (64GB) and ...
    Christiaan WillemsenChristiaan Willemsen
    Aug 20, 2008 at 10:54 pm
    Aug 29, 2008 at 5:08 am
  • Hi all, I've got a simple table with a lot of data in it: CREATE TABLE customer_data ( cd_id int primary key default(nextval('cd_seq')), cd_cust_id int not null, cd_variable text not null, cd_value ...
    Madison KellyMadison Kelly
    Aug 15, 2008 at 6:36 pm
    Aug 22, 2008 at 4:29 pm
  • [for the purpose of this post, 'blocking' refers to an I/O operation taking a long time for reasons other than the amount of work the I/O operation itself actually implies; not to use of blocking I/O ...
    Peter SchullerPeter Schuller
    Aug 22, 2008 at 12:01 pm
    Aug 29, 2008 at 3:55 am
  • Hi, I have a timestamptz field that I want to use with a query, but I don’t need the full timestamp resolution, so I’ve created a day_trunc(timestamptz) immutable function which I’ll use with the ...
    Giorgio ValotiGiorgio Valoti
    Aug 7, 2008 at 7:50 am
    Aug 8, 2008 at 5:39 am
  • I'm about to buy a combined web- and database server. When (if) the site gets sufficiently popular, we will split the database out to a separate server. Our budget is limited, so how should we ...
    ClusterCluster
    Aug 28, 2008 at 7:29 pm
    Sep 1, 2008 at 1:23 pm
  • Something goes wrong that this query plan thinks there is only gonna be 1 row from (SELECT uid FROM alog ... ) so chooses such query plan, and thus it runs forever (at least so long that I didn't ...
    MiernikMiernik
    Aug 9, 2008 at 8:39 pm
    Aug 10, 2008 at 3:30 am
  • I'm looking for some help in speeding up searches. My table is pretty simple (see below), but somewhat large, and continuously growing. Currently it has about 50 million rows. The table is (I know I ...
    Rainer MagerRainer Mager
    Aug 28, 2008 at 8:14 am
    Sep 8, 2008 at 3:54 am
  • Hello All, Ran into a re-occuring performance problem with some report queries again today. In a nutshell, we have filters on either multiple joined tables, or multiple columns on a single table that ...
    Chris KratzChris Kratz
    Aug 12, 2008 at 10:27 pm
    Aug 16, 2008 at 9:52 pm
  • Is there a way to use multi-level inheritance to achieve sub partitioning that the query optimizer will recognize? With our current application design, we would need a partition for every other day ...
    Jerry ChamplinJerry Champlin
    Aug 27, 2008 at 1:45 pm
    Aug 27, 2008 at 8:54 pm
  • We are attempting to turn off autovacuum but it keeps coming back. We can't afford the performance hit from vacuum while end users are accessing our system. Postgresql Version: 8.3.3 OS: Linux ...
    Jerry ChamplinJerry Champlin
    Aug 26, 2008 at 4:10 pm
    Aug 26, 2008 at 6:06 pm
  • Hello, I'm trying to install a solution to permit me to : - Secure the datas, without RAID - Giving ability to increase the potentiality of the database towards the needs. I have read about slony, ...
    DforumDforum
    Aug 9, 2008 at 5:29 pm
    Aug 12, 2008 at 3:18 pm
  • Hi list. I have a table with over 30 million rows. Performance was dropping steadily so I moved old data not needed online to an historic table. Now the table has about 14 million rows. I don't need ...
    Fernando HeviaFernando Hevia
    Aug 22, 2008 at 8:37 pm
    Aug 25, 2008 at 1:37 pm
  • Hi all, We started an attempt to slice the data we've been collecting in another way, to show the results of software vs. hardware RAID: ...
    Mark WongMark Wong
    Aug 20, 2008 at 5:23 am
    Aug 20, 2008 at 3:06 pm
  • Hackers and PG users, Does anyone see a need for having TOAST tables be individually configurable for autovacuum? I've finally come around to looking at being able to use ALTER TABLE for autovacuum ...
    Alvaro HerreraAlvaro Herrera
    Aug 13, 2008 at 9:28 pm
    Aug 14, 2008 at 9:43 am
  • Hi, Would you like to be so kind as to answer the following questions: - Is there any way to control the number of clog files and xlog files? I encounter an issue that there are too many clog files ...
    Duan LigongDuan Ligong
    Aug 27, 2008 at 1:09 am
    Aug 27, 2008 at 1:09 pm
  • Forgot to add asteriskpilot= SELECT version(); version -------------------------------------------------------------------------------------------------------- PostgreSQL 8.2.9 on ...
    Sergey HripchenkoSergey Hripchenko
    Aug 20, 2008 at 9:22 am
    Aug 20, 2008 at 1:49 pm
  • Hi, Following is the Query : SELECT sum(id), sum(cd), sum(ad) FROM table1 a , table2 b cross join table3 c WHERE a.nkey = b.key AND a.dkey = c.key AND c.date = '2008-02-01' AND b.id = 999 ; We have ...
    Gauri KanekarGauri Kanekar
    Aug 18, 2008 at 1:37 pm
    Aug 19, 2008 at 1:34 pm
  • Hello, We have a bit of a problem with the daily db backup. At the moment the backup db size is half of the main db, and we have the following errors in the log file: ERROR: out of memory DETAIL: ...
    Marcin CitowickiMarcin Citowicki
    Aug 6, 2008 at 10:21 am
    Aug 6, 2008 at 12:32 pm
  • Hello, I'm having trouble with a Nested Loop being selected for a rather complex query; it turns out this is a pretty bad plan as the nested loop's row estimates are quite off (1 estimated / 1207881 ...
    Brad EdigerBrad Ediger
    Aug 22, 2008 at 4:04 pm
    Aug 28, 2008 at 11:23 pm
  • It seems to me that the planner makes a very poor decision with this particular query: --- snip --- woome= explain analyze SELECT "webapp_invite"."id", "webapp_invite"."person_id", ...
    Frank JoerdensFrank Joerdens
    Aug 26, 2008 at 4:38 pm
    Aug 26, 2008 at 6:42 pm
  • Hello every body, I just discover a big not only big huge difference between NOW() and CURRENT_DATE. Did you already know about it and do you know why ? DELETE FROM blacklist where bl_date < (NOW() - ...
    DforumDforum
    Aug 24, 2008 at 8:03 pm
    Aug 25, 2008 at 6:13 am
  • I only have a few days of experience with postgres and it is working great, but when I start building up test queries I ran into a problem I don't understand. One query works fast, returning results ...
    Pgsql-performancePgsql-performance
    Aug 21, 2008 at 10:50 pm
    Aug 22, 2008 at 6:33 pm
  • Hi, Below command has been running since ~700 minutes in one of our PostgreSQL servers. DELETE FROM mugpsreglog WHERE NOT EXISTS (SELECT 1 FROM mueventlog WHERE mueventlog.eventlogid = ...
    Volkan YAZICIVolkan YAZICI
    Aug 7, 2008 at 6:09 am
    Aug 7, 2008 at 2:36 pm
  • Good morning, Tried to compare Table1 based on Table2 . update table1.col = false if table1.pk_cols not in table2.pk_cols For the following two ways, (2) always performs better than (1) right, and I ...
    Emi LuEmi Lu
    Aug 28, 2008 at 7:31 pm
    Aug 28, 2008 at 9:14 pm
  • Hello, We're developing a project which uses PostgreSQL to store binary documents. Since our system is likely to grow up to some terabytes in two years, I'd like to ask if some of you have had some ...
    Juliano FreitasJuliano Freitas
    Aug 14, 2008 at 6:09 pm
    Aug 16, 2008 at 9:52 pm
  • Hi list, I'm helping a customer with their new postgresql server and have some questions. The servers is connected to a SAN with dual raid cards which all have 512MB cache with BBU. The configuration ...
    HenrikHenrik
    Aug 7, 2008 at 9:46 am
    Aug 8, 2008 at 10:42 pm
  • Hello Regarding the advice from all, and the performance of postgresql 8.3.3 I'm trying to change the server and to upgrade to 8.3.3 I install postgresql 8.3.3 on a new server for testing. All ...
    DforumsDforums
    Aug 8, 2008 at 7:42 am
    Aug 8, 2008 at 7:56 am
  • Hello, I installed postgresql-8.3.3 in our local server with option --enable-nls . After successful installion , I create database and import data.But I am not aware how to use nls sort in this ...
    PraveenPraveen
    Aug 1, 2008 at 8:31 am
    Aug 1, 2008 at 8:43 am
  • Eh, there was a spurious join in that query which was created by an ORM which messed things up apparently. Sorry for the noise. This abstracted version of the original query that does the same is ...
    Frank JoerdensFrank Joerdens
    Aug 26, 2008 at 5:00 pm
    Aug 26, 2008 at 5:00 pm
  • unregister
    Sven ClementSven Clement
    Aug 11, 2008 at 2:51 pm
    Aug 11, 2008 at 2:51 pm
  • Hey all, I have two tables that look like this: CREATE TABLE details ( cust_code character varying(6) NOT NULL, cust_po character varying(20) NOT NULL, date_ordd date NOT NULL, item_nbr integer NOT ...
    ries van Twiskries van Twisk
    Aug 7, 2008 at 3:02 pm
    Aug 7, 2008 at 3:02 pm
Group Navigation
period‹ prev | Aug 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions42
posts432
users100
websitepostgresql.org
irc#postgresql

100 users for August 2008

Scott Marlowe: 27 posts Tom Lane: 24 posts David: 18 posts Matthew Wakeling: 18 posts Moritz Onken: 16 posts Greg Smith: 14 posts Mark Wong: 14 posts Scott Carey: 13 posts Alvaro Herrera: 12 posts Decibel!: 10 posts Dforums: 10 posts Loic Petit: 10 posts Gregory Stark: 9 posts Henrik: 9 posts Merlin Moncure: 9 posts Richard Huxton: 9 posts Bill Moran: 8 posts Ron Mayer: 8 posts Joshua Shanks: 7 posts André Volpato: 6 posts
show more
Archives