FAQ

Search Discussions

67 discussions - 479 posts

  • All, We have a table "table1" which get insert and updates daily in high numbers, bcoz of which its size is increasing and we have to vacuum it every alternate day. Vacuuming "table1" take almost ...
    Gauri KanekarGauri Kanekar
    Apr 28, 2008 at 1:39 pm
    Apr 30, 2008 at 4:47 pm
  • This refers to the performance problem reported in http://archives.postgresql.org/pgsql-performance/2008-04/msg00052.php After some time of trial and error we found that changing the I/O scheduling ...
    Albe LaurenzAlbe Laurenz
    Apr 11, 2008 at 11:22 am
    Jun 26, 2008 at 7:13 am
  • This week I've finished building and installing OSes on some new hardware at home. I have a pretty standard validation routine I go through to make sure PostgreSQL performance is good on any new ...
    Greg SmithGreg Smith
    Apr 17, 2008 at 7:58 am
    Apr 4, 2009 at 8:11 pm
  • In 8.3.0, I'm seeing some oddities with SQL functions which I thought were immune to the planner data restrictions of plpgsql functions and the sort. Basically I have a query which executes in 5ms ...
    Gavin M. RoyGavin M. Roy
    Apr 16, 2008 at 3:06 pm
    Apr 18, 2008 at 4:22 am
  • Hi We currently have a 16CPU 32GB box running postgres 8.2. When I do a pg_dump with the following parameters "/usr/bin/pg_dump -E UTF8 -F c -b" I get a file of 14GB in size. But the database is ...
    Adrian MoiseyAdrian Moisey
    Apr 14, 2008 at 6:39 am
    Apr 17, 2008 at 8:52 am
  • Hi all, I started to do some performance tests (using pgbench) in order to estimate the DRBD impact on our servers, my plan was to perform some benchmarks without DRBD in order to compare the same ...
    Gaetano MendolaGaetano Mendola
    Apr 14, 2008 at 9:12 am
    May 24, 2008 at 6:51 pm
  • Hi, I've started my first project with Postgres (after several years of using Mysql), and I'm having an odd performance problem that I was hoping someone might be able to explain the cause of. ----My ...
    John BeaverJohn Beaver
    Apr 9, 2008 at 8:58 pm
    Apr 10, 2008 at 9:33 pm
  • Hi everyone, I have some serious performance problems on a database where some queries take up to 100 (or even more) times longer occasionally. The database itself consists of one bigger table ...
    Thomas SprengThomas Spreng
    Apr 15, 2008 at 7:02 pm
    Apr 26, 2008 at 2:12 pm
  • Hi, I'm running into an performance problem where a Postgres db is running at 99% CPU (4 cores) with about 500 concurrent connection doing various queries from a web application. This problem started ...
    Bryan BueckingBryan Buecking
    Apr 22, 2008 at 3:38 pm
    Apr 22, 2008 at 11:59 pm
  • I am trying to get a distinct set of rows from 2 tables. After looking at someone else's query I noticed they were doing a group by to obtain the unique list. After comparing on multiple machines ...
    Francisco ReyesFrancisco Reyes
    Apr 18, 2008 at 3:55 am
    Apr 22, 2008 at 1:04 pm
  • Hi All, I´d like to know what´s the best practice to LOAD a 70 milion rows, 101 columns table from ORACLE to PGSQL. The current approach is to dump the data in CSV and than COPY it to Postgresql. ...
    Adonias MalossoAdonias Malosso
    Apr 26, 2008 at 1:25 pm
    Apr 29, 2008 at 3:31 am
  • Hi, to save some people a headache or two: I believe we just solved our performance problem in the following scenario: - Linux 2.6.24.4 - lots of RAM (32GB) - enough CPU power (4 cores) - disks with ...
    Marinos YannikosMarinos Yannikos
    Apr 16, 2008 at 3:23 pm
    Apr 23, 2008 at 5:26 am
  • Hi I have written a program that imputes(or rather corrects data) with in my database. Iam using a temporary table where in i put data from other partitoined table. I then query this table to get the ...
    Samantha mahindrakarSamantha mahindrakar
    Apr 7, 2008 at 6:27 pm
    Apr 10, 2008 at 3:26 pm
  • Hello everyone!! I have a table with 17 columns and it has almost 530000 records and doing just a SELECT * FROM table with the EXPLAIN ANALYZE I get: Seq Scan on table (cost=0.00...19452.95 ...
    Luigi N. PuleioLuigi N. Puleio
    Apr 9, 2008 at 9:58 am
    Apr 9, 2008 at 10:17 pm
  • I'm hitting an unexpected problem with postgres 8.3 - I have some tables which use varchar(32) for their unique IDs which I'm attempting to join using some simple SQL: select * from group_access, ...
    Adam GundyAdam Gundy
    Apr 10, 2008 at 3:14 am
    Apr 14, 2008 at 10:16 pm
  • Hello, I have a typical many to many join table, in this instance it is capturing the multiplicity described as "one person can have many rooms and one room can have many persons". Further the join ...
    Ravi ChemuduguntaRavi Chemudugunta
    Apr 1, 2008 at 12:23 am
    Apr 9, 2008 at 8:00 pm
  • Tried harder to find info on the write cycles: found som CFs that claim 2million cycles, and found the Mtron SSDs which claim to have very advanced wear levelling and a suitably long lifetime as a ...
    James MansionJames Mansion
    Apr 2, 2008 at 6:12 am
    Apr 3, 2008 at 5:58 pm
  • Hi, the following statement retrieves 16358 rows in a cursor by fetching 1024 rows in bulks on a 8.2.4 server: DECLARE curs_285058224 CURSOR FOR SELECT objid, attrid, aggrid, lineid, objval FROM ...
    Hell, RobertHell, Robert
    Apr 1, 2008 at 12:46 pm
    Apr 2, 2008 at 10:13 am
  • Hello, I am creating a large database of MD5 hash values. I am a relative newb with PostgreSQL (or any database for that matter). The schema and operation will be quite simple -- only a few tables, ...
    Jon StewartJon Stewart
    Apr 10, 2008 at 2:49 pm
    May 28, 2008 at 11:42 pm
  • We have a PostgreSQL 8.2.7 database (~230 GB) running on a machine with 8 Intel Xeon Cores and 32 GB RAM (64-bit Linux 2.6.18). Data is stored on an EMC² CLARiiON on RAID 1/0 (8 x 146 GB 15k rpm). ...
    Hell, RobertHell, Robert
    Apr 7, 2008 at 12:18 pm
    Apr 8, 2008 at 9:18 am
  • I hope I am posting to the right list. I am running Postgresql 8.1.9 and don't understand the behavior of histograms for data items not in the MVC list. I teach databases and want to use Postgres as ...
    Len ShapiroLen Shapiro
    Apr 30, 2008 at 5:03 am
    May 1, 2008 at 4:41 am
  • Hi all: We are loading in a number (100+) of sql files that are about 100M in size. It takes about three hours to load the file. There is very little load on the database other than the copy from ...
    John RouillardJohn Rouillard
    Apr 28, 2008 at 5:31 pm
    Apr 29, 2008 at 3:58 pm
  • So, it is time to improve performance, it is running to slow. AFAIK (as a novice) there are a few general areas: 1) hardware 2) rewriting my queries and table structures 3) using more predefined ...
    A BA B
    Apr 28, 2008 at 3:56 pm
    Apr 29, 2008 at 2:21 pm
  • I spent some time trying to come up with a test case, but had no luck. Dtrace showed that the running process was calling this function rather excessively; sample profiling for 30 seconds would look ...
    Robert TreatRobert Treat
    Apr 21, 2008 at 4:29 pm
    Apr 26, 2008 at 11:20 pm
  • I cannot understand why the following two queries differ so much in execution time (almost ten times) Query A (two queries) select distinct moment.mid from moment,timecard where parent = 45 and ...
    Hans EkbrandHans Ekbrand
    Apr 23, 2008 at 7:38 am
    Apr 23, 2008 at 1:31 pm
  • This autovacuum has been hammering my server with purely random i/o for half a week. The table is only 20GB and the i/o subsystem is good for 250MB/s sequential and a solid 5kiops. When should I ...
    Jeffrey BakerJeffrey Baker
    Apr 18, 2008 at 4:35 pm
    Apr 19, 2008 at 5:57 am
  • Hi, I have a performance problem with a script that does massive bulk insert in 6 tables. When the script starts the performance is really good but will degrade minute after minute and take almost a ...
    Christian BourqueChristian Bourque
    Apr 8, 2008 at 3:02 am
    Apr 8, 2008 at 10:44 pm
  • Hi folks, Here is the executive summary: * RHEL5 (postgresql 8.1, .conf tweaked for performance [1]) * 2x Intel E5410 @ 2.33GHz (8 cores), 8GB RAM, 15KRPM SAS disks * 4.9 million records in a table ...
    Dimi PaunDimi Paun
    Apr 7, 2008 at 3:51 pm
    Apr 7, 2008 at 7:38 pm
  • (thread crossed over to pgsql-performance, where it belongs, from pgsql-advocacy) Greg, You'd be surprised, then. We're still horribly, horribly lock-bound on TPC-E; on anything over 4 cores lock ...
    Josh BerkusJosh Berkus
    Apr 27, 2008 at 5:54 pm
    May 1, 2008 at 2:22 pm
  • Thinking about buying the Powervault MD3000 SAS array with 15 15k 300GB disks for use as a postgres tablespace. Is anyone using these (or other LSI/Engenio rebadge jobs?). I'm interested in hearing ...
    Jeffrey BakerJeffrey Baker
    Apr 16, 2008 at 8:15 pm
    Apr 17, 2008 at 12:08 am
  • just wondering if there's a special tweak i can do to force more usage of indexes to do BITMAP ands? I have a table like A int B int C int D int E int F int g int where A/B/C/D/E are indexes There's ...
    Ow Mun HengOw Mun Heng
    Apr 4, 2008 at 6:03 am
    Apr 8, 2008 at 11:02 am
  • I'm trying to fine tune this query to return in a reasonable amount of time and am having difficulties getting the query to run the way I'd like. I have a couple of semi-related entities that are ...
    Matt KlinkerMatt Klinker
    Apr 3, 2008 at 11:31 pm
    Apr 7, 2008 at 3:46 pm
  • I found strange issue in very simple query. Statistics for all columns is on the level 1000 but I also tried other levels. create table g ( id bigint primary key, isgroup boolean not null); create ...
    Vlad ArkhipovVlad Arkhipov
    Apr 24, 2008 at 1:15 am
    Apr 28, 2008 at 1:54 am
  • Hi there, I have a table which looks similar to: CREATE TABLE accounting ( id text NOT NULL, time timestamp with time zone, data1 int, data2 int, data3 int, data4 int, data5 int, data6 int, data7 ...
    Gunther MayerGunther Mayer
    Apr 17, 2008 at 9:35 am
    Apr 19, 2008 at 4:48 pm
  • When traffic to our PostgreSQL-backed website spikes, the first resource we see being exhausted is the DB slots on the master server (currently set to about 400). I expect that as new Apache/mod_perl ...
    Mark StosbergMark Stosberg
    Apr 7, 2008 at 6:40 pm
    Apr 11, 2008 at 2:44 pm
  • Hi List; Sorry if this is a dupe, my first post never showed up... I'm having some performance issues with a partitioned table. We have a VERY large table that we've partitioned by day. Currently we ...
    Kevin kempterKevin kempter
    Apr 5, 2008 at 12:48 am
    Apr 11, 2008 at 10:37 am
  • Hi, I'm having trouble understanding the cost of the Materialize operator. Consider the following plan: Nested Loop (cost=2783.91..33217.37 rows=78634 width=44) (actual time=77.164..2478.973 rows=309 ...
    Viktor RosenfeldViktor Rosenfeld
    Apr 21, 2008 at 11:16 am
    Apr 27, 2008 at 7:02 pm
  • I have a question about index us and IO and am seeking advice. We are running postgres 8.2. We have two big big tables. Our ~600,000,000 row table is changed very infrequently and is on a 12 disk ...
    Nikolas EverettNikolas Everett
    Apr 24, 2008 at 1:59 pm
    Apr 24, 2008 at 7:57 pm
  • Hi # ps -ef | grep idle | wc -l 87 # ps -ef | grep SELECT | wc -l 5 I have 2 web servers which connect to PGPool which connects to our postgres db. I have noticed that idle connections seem to take ...
    Adrian MoiseyAdrian Moisey
    Apr 21, 2008 at 9:50 am
    Apr 23, 2008 at 12:47 am
  • Hi. I have this "message queue" table.. currently with 8m+ records. Picking the top priority messages seem to take quite long.. it is just a matter of searching the index.. (just as explain analyze ...
    Jesper KroghJesper Krogh
    Apr 18, 2008 at 5:50 pm
    Apr 18, 2008 at 8:26 pm
  • I recall reading posts in the past where one could query the stat tables and see how well autovacuum was performing. Not finding the posts. I found this query: SELECT relname, relkind, reltuples, ...
    Francisco ReyesFrancisco Reyes
    Apr 29, 2008 at 12:14 pm
    May 4, 2008 at 4:59 am
  • This is the best write-up I've seen yet on quantifying what SSDs are good and bad at in a database context: http://www.bigdbahead.com/?p=37 -- * Greg Smith gsmith@gregsmith.com ...
    Greg SmithGreg Smith
    Apr 29, 2008 at 6:55 pm
    Apr 29, 2008 at 11:27 pm
  • Hi List; I have a large tble (playback_device) with 6million rows in it. The aff_id_tmp1 table has 600,000 rows. I also have this query: select distinct tmp1.affiliate_id, tmp1.name, ...
    Kevin kempterKevin kempter
    Apr 17, 2008 at 6:24 pm
    Apr 17, 2008 at 11:48 pm
  • Hi All, We are using solaris 10 x86/AMD Opteron and postgresql 8.2 on SunFire X2100 , however performance is very slow in contrast to linux debian in the same platform. Is this normal? Thanks & ...
    MUNAGALA REDDYMUNAGALA REDDY
    Apr 3, 2008 at 11:45 am
    Apr 11, 2008 at 8:26 pm
  • The http://www.1-800-save-a-pet.com site is hosted with FreeBSD and PostgreSQL and as a geo-spatial search as a central feature. One thing that made a substantial performance improvement was ...
    Mark StosbergMark Stosberg
    Apr 7, 2008 at 6:35 pm
    Apr 8, 2008 at 5:39 pm
  • Hi all, looking for a HA master/master or master/slave replication solution. Our setup consists of two databases and we want to use them both for queries. Aside from pgpool II there seems no ...
    Gernot SchwedGernot Schwed
    Apr 30, 2008 at 3:56 pm
    May 1, 2008 at 9:34 am
  • Hi All! We have a database running smoothly for months. 2 days ago I get this error message. I tried a restore, a full restore (deleting the old database and recovering from backup all the ...
    Pablo AlcarazPablo Alcaraz
    Apr 20, 2008 at 8:00 pm
    Apr 29, 2008 at 12:19 pm
  • Hi All, This query is being executed nearly a million times.... SELECT 'DBD::Pg ping test' Why this is being executed ? What is the use ? Am sure that this query is not executed explicitly. am using ...
    Sathiya psqlSathiya psql
    Apr 23, 2008 at 7:19 am
    Apr 23, 2008 at 4:40 pm
  • Hello, i have a postgresql server running and from time to time it gets painfully slow. When this happens i usually connect to the server and run a "top" command, the output i get is filled with ...
    Rafael Barrera OroRafael Barrera Oro
    Apr 22, 2008 at 5:37 pm
    Apr 23, 2008 at 5:43 am
  • Hi all, I´m running a copy for a 37G CSV and receiving the following error: "invalid string enlargement request size 65536" The file has about 70 million lines with 101 columns, all them varchar. ...
    Adonias MalossoAdonias Malosso
    Apr 22, 2008 at 9:05 pm
    Apr 23, 2008 at 3:31 am
Group Navigation
period‹ prev | Apr 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions67
posts479
users122
websitepostgresql.org
irc#postgresql

122 users for April 2008

Tom Lane: 38 posts Greg Smith: 30 posts PFC: 27 posts Matthew Wakeling: 19 posts Craig Ringer: 18 posts Gauri Kanekar: 14 posts Pavan Deolasee: 12 posts Gregory Stark: 10 posts Adrian Moisey: 9 posts Alvaro Herrera: 9 posts James Mansion: 9 posts Jeffrey Baker: 9 posts Bill Moran: 8 posts Hell, Robert: 8 posts Joshua D. Drake: 8 posts Richard Huxton: 8 posts Chris Browne: 7 posts Heikki Linnakangas: 7 posts Samantha mahindrakar: 7 posts Thomas Spreng: 7 posts
show more
Archives