FAQ

Search Discussions

56 discussions - 414 posts

  • Hi. I just created partitioned table, n_traf, sliced by month (n_traf_y2007m01, n_traf_y2007m02... and so on, see below). They are indexed by 'date_time' column. Then I populate it (last value have ...
    AntonAnton
    Aug 24, 2007 at 8:53 am
    Mar 12, 2008 at 7:16 pm
  • I have a table with 4,889,820 records in it. The table also has 47 fields. I'm having problems with update performance. Just as a test, I issued the following update: update valley set test='this is ...
    Mark MakarowskyMark Makarowsky
    Aug 7, 2007 at 12:58 pm
    Aug 9, 2007 at 3:32 pm
  • We have a 30 GB database (according to pg_database_size) running nicely on a single Dell PowerEdge 2850 right now. This represents data specific to 1 US state. We are in the process of planning a ...
    Joe UhlJoe Uhl
    Aug 9, 2007 at 8:02 pm
    Aug 14, 2007 at 12:59 am
  • Hi, We turned on autovacuums on 8.2 and we have a database which is read only , it is basically a USPS database used only for address lookups (only SELECTS, no updates/deletes/inserts). This database ...
    Pallav KalvaPallav Kalva
    Aug 31, 2007 at 3:31 pm
    Aug 31, 2007 at 11:48 pm
  • I'm have the following view as part of a larger, aggregate query that is running slower than I'd like. There are 4 views total, each very similar to this one. Each of the views is then left joined ...
    Relyea, MikeRelyea, Mike
    Aug 10, 2007 at 5:04 pm
    Aug 20, 2007 at 2:03 pm
  • Hello everybody, as I'm new to this list I hope that it is the right place to post this and also the right format, so if I'm committing an error, I apologize in advance. First the background of my ...
    Sven ClementSven Clement
    Aug 3, 2007 at 1:59 pm
    Aug 7, 2007 at 2:07 pm
  • I have a PostgreSQL 8.2.4 table with some seven million rows. The psql query: select count(rdate),rdate from reading where sensor_id in (1137,1138,1139) group by rdate order by rdate desc limit 1; ...
    Stephen DaviesStephen Davies
    Aug 22, 2007 at 2:40 am
    Aug 24, 2007 at 2:19 am
  • Is there any way to stop the autovacuum if it is running longer than 10 min or so? Is it good idea to kill autovacuum if it is running longer than expected? In my OLTP system, we are inserting, ...
    Sachchida OjhaSachchida Ojha
    Aug 21, 2007 at 9:26 pm
    Aug 21, 2007 at 11:16 pm
  • Dearest dragon hunters and mortal wanna-bes, I recently upgraded a system from Apache2/mod_perl2 to Lighttpd/fastcgi. The upgrade went about as rough as can be. While in the midst of a bad day, I ...
    Evan CarrollEvan Carroll
    Aug 28, 2007 at 3:22 pm
    Sep 1, 2007 at 12:09 am
  • Hello! We run a large (~66Gb) web-backend database on Postgresql 8.2.4 on Linux. The hardware is Dual Xeon 5130 with 16Gb ram, LSI Megaraid U320-2x scsi controller w/512Mb writeback cache and a BBU. ...
    Dmitry PotapovDmitry Potapov
    Aug 22, 2007 at 3:33 pm
    Aug 28, 2007 at 9:34 pm
  • Hi List; I've just started working with a client that has been running Postgres (with no DBA) for a few years. They're running version 8.1.4 on 4-way dell boxes with 4Gig of memory on each box ...
    Kevin KempterKevin Kempter
    Aug 24, 2007 at 8:05 pm
    Aug 27, 2007 at 10:07 pm
  • Hi I wanted to know if the integrated perc 5/i which come with Dell 2950 will yield maximum performance from RAID 10 ( 15K SAS ). Or should I ask for different card ? I read an old post that shows ...
    Michael Ben-NesMichael Ben-Nes
    Aug 16, 2007 at 8:52 am
    Aug 17, 2007 at 1:13 am
  • Hi, Note: I have already vacumm full. It does not solve the problem. I have a postgres 8.1 database. In the last days I have half traffic than 4 weeks ago, and resources usage is twice. The resource ...
    Ruben RubioRuben Rubio
    Aug 27, 2007 at 11:48 am
    Aug 31, 2007 at 7:36 pm
  • Hi, I have an application which loads millions of NEW documents each month into a PostgreSQL tsearch2 table. I have the initial version completed and searching performance is great but my problem is ...
    Benjamin AraiBenjamin Arai
    Aug 25, 2007 at 12:42 am
    Aug 25, 2007 at 8:09 pm
  • Hello all, I am trying to enable capturing of the submitted code via an application...how do I do this in Postgres? Performance is SLOW on my server and I have autovacuum enabled as well as rebuilt ...
    Smiley2211Smiley2211
    Aug 8, 2007 at 8:02 pm
    Aug 13, 2007 at 4:13 pm
  • Hi, Maybe not completely the wright place to ask but... I have this schema design question (db is postgres of course). I have a couple of classes with attributes. The only goal is to search the ...
    Mark overmeerMark overmeer
    Aug 19, 2007 at 1:19 pm
    Aug 20, 2007 at 12:22 am
  • Hello Group, I'm new in PostgreSQL Business, therefore please forgive me a "newbie" Question. I have a table with ca. 1.250.000 Records. When I execute a "select count (*) from table" (with pgAdmin ...
    RunicRunic
    Aug 8, 2007 at 1:01 pm
    Aug 18, 2007 at 1:14 am
  • Hello. I have a postgres 8.0 and ~400mb database with lots of simple selects using indexes. I've installed pgpool on the system. I've set num_init_children to 5 and here is the top output. One of ...
    Max ZorloffMax Zorloff
    Aug 25, 2007 at 8:24 pm
    Aug 30, 2007 at 5:42 am
  • For best performance, the transaction log should be on a separate disk. Does the writing of the log benefit from a battery backed controller as well? If not, what do people think about writing the ...
    Markus BenneMarkus Benne
    Aug 29, 2007 at 7:29 pm
    Aug 29, 2007 at 8:37 pm
  • I have read that trigram matching (similarity()) performance degrades when the matching is on longer strings such as phrases. I need to quickly match strings and rate them by similiarity. The strings ...
    Carlo StonebanksCarlo Stonebanks
    Aug 22, 2007 at 4:02 pm
    Aug 22, 2007 at 9:09 pm
  • Hello everyone, This being my first e-mail to the mailing list, I hope my question is relevant and on-topic. I'm seeing poor performance on a few queries where the planner decides to use a bitmap ...
    Frank SchoepFrank Schoep
    Aug 16, 2007 at 4:33 pm
    Aug 17, 2007 at 3:59 pm
  • Hi All, Tomas Kovarik and I have presented at PGCon 2007 in Ottawa the ideas about other possible optimizer algorithms to be used in PostgreSQL. We are quite new to PostgreSQL project so it took us ...
    Julius StroffekJulius Stroffek
    Aug 13, 2007 at 7:51 pm
    Aug 13, 2007 at 11:18 pm
  • Hi list, I'm having a weird acting query which simply retrieves some files stored in a db which are related to a specific archive and also has a size lower than 1024 bytes. Explain analyze below. The ...
    Henrik ZagerholmHenrik Zagerholm
    Aug 6, 2007 at 12:22 pm
    Aug 6, 2007 at 10:23 pm
  • Hello! Some background info.. We have a blog table that contains about eight million blog entries. Average length of an entry is 1200 letters. Because each 8k page can accommodate only a few entries, ...
    Kari LavikkaKari Lavikka
    Aug 28, 2007 at 6:53 pm
    Aug 29, 2007 at 10:15 am
  • Should installation questions be sent here or to the admin listserv? OS: redhat linux Version of PostgreSQL: 8.2.4 I had a group that now manages our server set up a directory/partition for us to put ...
    Campbell, LanceCampbell, Lance
    Aug 23, 2007 at 4:47 pm
    Aug 23, 2007 at 5:38 pm
  • Hi, I have just reorganized a relatively decent sized query such that its constituent functions / tables are now spread over 3-4 schemas. However, the query has for some reason now become very slow ...
    RobinsRobins
    Aug 28, 2007 at 1:05 pm
    Aug 29, 2007 at 2:45 am
  • Hi List; I've just inherited multiple postgres database servers in multiple data centers across the US and Europe via a new contract I've just started. Each night during the nightly batch processing ...
    Kevin KempterKevin Kempter
    Aug 28, 2007 at 4:15 am
    Aug 28, 2007 at 2:32 pm
  • Hi Guys, I have something odd. I have Gallery2 running on PostgreSQL 8.1, and recently I upgraded to 8.1.9-1.el4s1.1 (64bit). The issue here really is how do I get PostgreSQL to work with their ...
    Willo van der MerweWillo van der Merwe
    Aug 27, 2007 at 1:18 pm
    Aug 28, 2007 at 9:34 am
  • Nik, you may be underestimating just how much performance can be obtained from a single database server. For example, an IBM p595 server connected to an array of ds8300 storage devices could ...
    Andrew HammondAndrew Hammond
    Aug 19, 2007 at 7:48 pm
    Aug 20, 2007 at 12:37 am
  • Hello, Whe are running PostgreSQL 8.2.0 on amd64-portbld-freebsd6.2, compiled by GCC cc (GCC) 3.4.6 [FreeBSD] 20060305. The query only uses the index if we have a "limit n": Without "Limit n" explain ...
    Sebastián BaioniSebastián Baioni
    Aug 15, 2007 at 7:43 pm
    Aug 16, 2007 at 11:09 pm
  • Hello list, We have a database keeping track of old files on different computers. We have now added some search functionality to this system. The problem is that on some searches it is really really ...
    Henrik ZagerholmHenrik Zagerholm
    Aug 6, 2007 at 9:19 am
    Aug 6, 2007 at 8:17 pm
  • Hi, We have recently upgraded our production database from 8.0.12 to 8.2.4, We have seen lot of improvements on 8.2.4 side but we are also seeing some queries which are slow. Particularly this below ...
    Pallav KalvaPallav Kalva
    Aug 28, 2007 at 3:09 pm
    Aug 28, 2007 at 9:06 pm
  • I see some long running transaction in my pg_activity_log table. My app becomes almost unusable. My question is How can I query the database to see what sql these transactions are running. ...
    Sachchida OjhaSachchida Ojha
    Aug 22, 2007 at 8:43 pm
    Aug 22, 2007 at 9:58 pm
  • Hi, I recently inherited a very old (PostgreSQL 7.0.3) database, and have migrated it to 8.2.4 but have run into a performance issue. Basically, I did a dump and import into the new database, ...
    Ben PerraultBen Perrault
    Aug 21, 2007 at 5:46 am
    Aug 22, 2007 at 10:56 am
  • Hi, we are using Postgres on both Solaris servers and Linux servers, and Postgres are much slower on Solaris servers. We have tested with different versions of Solaris and Postgres, but the fact ...
    Fredrik BertilssonFredrik Bertilsson
    Aug 17, 2007 at 6:50 am
    Aug 21, 2007 at 3:50 pm
  • Hello! Here's my test database: # table CREATE TABLE public.t ( id integer NOT NULL, a integer NOT NULL, CONSTRAINT pk_t PRIMARY KEY (id) ) CREATE INDEX idx_t_a ON public.t USING btree (a); # ...
    Philipp SpechtPhilipp Specht
    Aug 13, 2007 at 8:19 pm
    Aug 15, 2007 at 8:48 pm
  • Hi folks, I'm often using writable views as interfaces to clients, so they only see "virtual" objects and never have to cope with the actual storage, ie. to give some client an totally denormalized ...
    Enrico WeigeltEnrico Weigelt
    Aug 8, 2007 at 12:42 pm
    Aug 13, 2007 at 10:18 pm
  • I saw an interesting topic in the archives on best bang for the buck for $20k.. about a year old now. So whats the thoughts on a current combined rack/disks/cpu combo around the $10k-$15k point, ...
    JustinJustin
    Aug 9, 2007 at 3:35 am
    Aug 9, 2007 at 2:40 pm
  • We have a complicated stored procedure that we run frequently. It pegs one of our postmaster processes at 100% CPU utilization for a few hours. This has the unfortunate side effect of causing ...
    Bryan MurphyBryan Murphy
    Aug 2, 2007 at 4:08 pm
    Aug 3, 2007 at 10:18 pm
  • ************************************************************************************************************************* 1) EXPLAIN ANALYSE SELECT ...
    Karthikeyan MahadevanKarthikeyan Mahadevan
    Aug 29, 2007 at 12:41 pm
    Aug 29, 2007 at 5:52 pm
  • Hello, I have a table (stats.tickets) with 2288965 rows (51 columns) and indexes like: ind_ti_stats_numero btree (tday, tmonth, tyear, r_cat, r_numero) ind_ti_stats_service btree (tday, tmonth, ...
    PaulPaul
    Aug 28, 2007 at 8:49 am
    Aug 29, 2007 at 8:16 am
  • I'm testing the new asynch commit feature on various raid configurations and my early findings is that it reduces the impact of keeping wal and data on the same volume. I have 10 disks to play with, ...
    Merlin MoncureMerlin Moncure
    Aug 23, 2007 at 1:09 pm
    Aug 27, 2007 at 9:18 pm
  • After reading many articles which indicate the more disk spindles the better performance and separating indexes, WAL and data on different sets of spindles, I've come up with a couple of questions. ...
    Robert D OdenRobert D Oden
    Aug 16, 2007 at 5:02 pm
    Aug 23, 2007 at 9:31 pm
  • I am having some dead locking problem with my app system. Our dev are debugging the app to find out the cause of the problem. In the mean time I looked at postgresql.conf file. I found that there is ...
    Sachchida OjhaSachchida Ojha
    Aug 23, 2007 at 6:22 pm
    Aug 23, 2007 at 6:52 pm
  • Terminology Question: If I use the following statement: I am backing up schema XYZ every 30 minutes. Does this statement imply that I am only backing up the definition of the data? Or does it mean ...
    Campbell, LanceCampbell, Lance
    Aug 20, 2007 at 2:36 pm
    Aug 20, 2007 at 5:55 pm
  • Hi We currently have some databases running under 8.0 and 8.1. I have noticed a significant difference in the time taken to restore dumps between the two versions, with 8.0 being much faster. For ...
    Ted JordanTed Jordan
    Aug 4, 2007 at 8:36 pm
    Aug 6, 2007 at 5:59 pm
  • I notice that I get different plans when I run the following two queries that I thought would be identical. select distinct test_col from mytable; select test_col from mytable group by test_col; Any ...
    Ron MayerRon Mayer
    Aug 2, 2007 at 9:32 pm
    Aug 3, 2007 at 12:48 am
  • Hi all, I'm having a strange performance issue with two almost similar queries, the one running as expected, the other one taking far more time. The only difference is that I have "uniid in (10)" in ...
    Jens ReufsteckJens Reufsteck
    Aug 29, 2007 at 10:16 am
    Aug 29, 2007 at 2:33 pm
  • Hi List; I've just started working with a new client and they have amoung other issues with their databases a particular update that basically locks out users. The below query was running for over 6 ...
    Kevin KempterKevin Kempter
    Aug 23, 2007 at 5:24 pm
    Aug 23, 2007 at 6:56 pm
  • Is there any way to stop the autovacuum if it is running longer than 10 min or so? Is it good idea to kill autovacuum if it is running longer than expected? In my OLTP system, we are inserting, ...
    Sachchida OjhaSachchida Ojha
    Aug 21, 2007 at 9:30 pm
    Aug 21, 2007 at 9:47 pm
Group Navigation
period‹ prev | Aug 2007 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions56
posts414
users115
websitepostgresql.org
irc#postgresql

115 users for August 2007

Tom Lane: 34 posts Jim Nasby: 20 posts Scott Marlowe: 17 posts Kevin Grittner: 15 posts Merlin Moncure: 14 posts Sachchida Ojha: 11 posts Alvaro Herrera: 10 posts Heikki Linnakangas: 10 posts Joshua D. Drake: 10 posts Bill Moran: 8 posts Gregory Stark: 8 posts Steinar H. Gunderson: 8 posts Henrik Zagerholm: 7 posts Kevin Kempter: 7 posts Mark Lewis: 7 posts Steven Flatt: 7 posts Erik Jones: 6 posts Greg Smith: 6 posts Luke Lonergan: 6 posts Pallav Kalva: 6 posts
show more
Archives