FAQ

PostgreSQL > pgsql-performance > September 2010

Search Discussions

30 discussions - 213 posts

  • Hi, After reading lots of documentation, I still don't understand fully how PG knows if some needed data is in memory or in second storage. While choosing the best query plan, the optimizer must take ...
    Fabrício dos Anjos SilvaFabrício dos Anjos Silva
    Sep 29, 2010 at 4:31 pm
    Oct 28, 2010 at 3:31 pm
  • We've come to a tipping point with one of our database servers, it's generally quite loaded but up until recently it was handling the load well - but now we're seeing that it struggles to process all ...
    Tobias BroxTobias Brox
    Sep 23, 2010 at 9:51 pm
    Sep 30, 2010 at 9:01 pm
  • Hi all, I have a view v_table defined as following: select a,b,c,d,e,f from t_table sort by a,b,c; the usage pattern of this view is the following: select distinct(a) from v_table; select distinct(b) ...
    Gaetano MendolaGaetano Mendola
    Sep 13, 2010 at 9:53 am
    Oct 25, 2010 at 10:24 am
  • Howdy, I'm running pgbench with a fairly large # of clients and getting this error in my PG log file. Here's the command: ./pgbench -c 1100 testdb -l I get: LOG: could not send data to client: Broken ...
    David KerrDavid Kerr
    Sep 8, 2010 at 5:46 pm
    Sep 9, 2010 at 6:07 pm
  • Hello, I have received some help from the IRC channel, however, the problem still exists. When running the following query with enable_seqscan set to 0, it takes less than a second, whereas with it ...
    OgdenOgden
    Sep 21, 2010 at 5:39 pm
    Oct 28, 2010 at 4:21 pm
  • We have a production database server ... it's quite busy but usually working completely fine, simple queries taking a fraction of a millisecond to run. Recently we've frequently encountered issues ...
    Tobias BroxTobias Brox
    Sep 15, 2010 at 10:06 am
    Sep 23, 2010 at 10:50 pm
  • All, I've been looking at pg_stat_user_tables (in 8.3, because of a project I have), and it appears that autovacuum, and only autovaccum, updates the data for this view. This means that one can never ...
    Josh BerkusJosh Berkus
    Sep 13, 2010 at 11:06 pm
    Sep 16, 2010 at 7:34 pm
  • The autovacuum daemon currently uses the number of inserted and updated tuples to determine if it should run VACUUM ANALYZE on a table. Why doesn’t it consider deleted tuples as well? For example, I ...
    Joe MillerJoe Miller
    Sep 20, 2010 at 8:38 pm
    Oct 26, 2010 at 12:24 pm
  • Hi everyone. I have a question, and it's well beyond me to even speculate about the inner workings of postgresql on this. I have a "places" table, and a "coordinates" column, of type POINT. If I want ...
    Marcelo ZabaniMarcelo Zabani
    Sep 30, 2010 at 6:33 pm
    Oct 12, 2010 at 12:52 am
  • Hello, I have I query which behave strangely (according to me). According to the first plan PG makes absolutely unnecessary seq scan on tables "invoices" and "domeini" and etc. I thing they should be ...
    Kaloyan Iliev IlievKaloyan Iliev Iliev
    Sep 3, 2010 at 4:45 pm
    Sep 7, 2010 at 4:55 pm
  • I'm doing an OS upgrade and have been sitting on 8.4.3 for sometime. I was wondering if it's better for the short term just to bring things to 8.4.4 and let 9.0 bake a bit longer, or are people with ...
    Tory M BlueTory M Blue
    Sep 28, 2010 at 7:22 pm
    Oct 27, 2010 at 3:19 pm
  • Hi all I've have a strange problem with my Windows postgresql-9.0 service stopping after any transaction which manipulates tables in any database (Deleting records, Inserting records, bulk importing ...
    Adrian KitchingmanAdrian Kitchingman
    Sep 24, 2010 at 4:55 am
    Sep 30, 2010 at 6:00 am
  • Hi, I am confronted with a use case where my database mainly does big aggregate select (ROLAP), a bunch of batch jobs, and quite few OLTP. I come into cases where the planner under-estimates the ...
    Franck RoutierFranck Routier
    Sep 16, 2010 at 8:31 am
    Sep 26, 2010 at 4:02 am
  • Our Java application manages its own schema. Some of this is from Hibernate, but some is hand-crafted JDBC. By way of an upgrade path, we have a few places where we have added additional indexes to ...
    Dave CrookeDave Crooke
    Sep 27, 2010 at 6:50 pm
    Oct 7, 2010 at 9:51 pm
  • Hello! I have this table: create table test ( s1 varchar(255), s2 varchar(255), i1 integer, i2 integer, ... over 100 other fields ); table contains over 8 million records there's these indexes: ...
    Dmitry TeslenkoDmitry Teslenko
    Sep 23, 2010 at 2:26 pm
    Sep 27, 2010 at 5:30 pm
  • Hello all, I am trying to use aggregate queries in views, and when joining these views to other tables, I get seq scan in the view, even if index scan would be clearly better. The views I am using in ...
    Anssi KääriäinenAnssi Kääriäinen
    Sep 15, 2010 at 6:19 am
    Sep 16, 2010 at 2:53 pm
  • Hello, I am relatively new to postgres (just a few months) so apologies if any of you are bearing with me. I am trying to get a rough idea of the amount of bang for the buck I might see if I put in a ...
    MarkMark
    Sep 14, 2010 at 4:10 pm
    Sep 14, 2010 at 5:14 pm
  • Hi all. I Have the following query (tested in postgres 8.4 and 9.0rc1) SELECT distinct event0_.* FROM event event0_ inner join account account1_ on event0_.account_id_owner=account1_.account_id LEFT ...
    Mason HardingMason Harding
    Sep 10, 2010 at 10:35 pm
    Sep 11, 2010 at 2:03 am
  • Hi, I have this situation: Database size: 7,6GB (on repository) Memory size: 7,7GB 1 CPU: aprox. 2GHz Xeon Number of tables: 1 (empresa) CREATE TABLE "public"."empresa" ( "cdempresa" INTEGER NOT ...
    Fabrício dos Anjos SilvaFabrício dos Anjos Silva
    Sep 29, 2010 at 4:55 pm
    Oct 3, 2010 at 9:40 pm
  • Hello, we are experiencing some performance degradation on a database where the main table is running towards the 100M record. Together with the slowness of the queries I notice these symptoms: - ...
    Daniele VarrazzoDaniele Varrazzo
    Sep 20, 2010 at 11:59 am
    Sep 22, 2010 at 4:20 am
  • Since I've never stumbled on this until now, and I spend all day looking at this sort of thing, I'm guessing many of you haven't seen the following collection of 3ware controller trivia either: ...
    Greg SmithGreg Smith
    Sep 18, 2010 at 7:50 am
    Sep 20, 2010 at 10:10 pm
  • I have a problem with some simple query: select version(); PostgreSQL 8.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7) vacuum full bug_t1; vacuum full bug_t2; ...
    AzajacAzajac
    Sep 13, 2010 at 5:49 am
    Sep 13, 2010 at 3:16 pm
  • I've created a few user-defined types quite similar to uuid which we use to store various hashes in the database. (The types use binary encoding internally, but only expose hexadecimal strings ...
    Florian WeimerFlorian Weimer
    Sep 3, 2010 at 2:15 pm
    Sep 3, 2010 at 3:28 pm
  • Hi, Are there any significant performance improvements or regressions from 8.4 to 9.0? If yes, which areas (inserts, updates, selects, etc) are those in? In a related question, is there any public ...
    AndyAndy
    Sep 30, 2010 at 12:02 am
    Sep 30, 2010 at 5:15 am
  • Hi, Can any one of you suggest how the archived Xlogs can be cleaned in postgres-9. We want to use streaming replication and have set the "wal_level" to "hot_standby" and "archive_mode" to "on". ...
    Nimesh SatamNimesh Satam
    Sep 28, 2010 at 10:01 am
    Sep 28, 2010 at 12:29 pm
  • While everybody else was talking about a new software release or something today, I was busy finally nailing down something elusive that pops up on this list regularly. A few weeks ago we just had a ...
    Greg SmithGreg Smith
    Sep 21, 2010 at 4:20 am
    Sep 27, 2010 at 4:53 pm
  • Hi All, (pg 8.3.7 on RHEL 2.6.18-92.el5 ) I ran the query below (copied from http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html ) on a production DB we have and I am looking at some pretty ...
    MarkMark
    Sep 20, 2010 at 5:25 pm
    Sep 20, 2010 at 7:24 pm
  • Sorry for the blast... I am running into a POSTGRES error. It appears to be the DBMGR[4289]. Any ideas what the error maybe? [cid:[email protected]]
    Timothy NoonanTimothy Noonan
    Sep 15, 2010 at 11:31 am
    Sep 15, 2010 at 1:38 pm
  • All, I have a reporter who wants to talk to a data warehousing user of PostgreSQL ( 1TB preferred), on the record, about 9.0. Please e-mail me if you are available and when good times to chat would ...
    Josh BerkusJosh Berkus
    Sep 20, 2010 at 6:48 pm
    Sep 20, 2010 at 6:48 pm
  • I have a problem with some simple query: select version(); PostgreSQL 8.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7) vacuum full bug_t1; vacuum full bug_t2; ...
    AzajacAzajac
    Sep 12, 2010 at 6:16 pm
    Sep 12, 2010 at 6:16 pm
Sep 2010
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions30
posts213
users56
websitepostgresql.org
irc#postgresql

56 users for September 2010

Tom Lane: 27 posts Kevin Grittner: 18 posts Tobias Brox: 16 posts Greg Smith: 15 posts Gerhard Wiesinger: 14 posts Robert Haas: 11 posts David Kerr: 8 posts Merlin Moncure: 8 posts Josh Berkus: 6 posts Ogden: 5 posts Adrian Kitchingman: 4 posts Brad Nicholson: 4 posts Gaetano Mendola: 4 posts Joshua D. Drake: 4 posts Kaloyan Iliev Iliev: 4 posts Joe Miller: 3 posts Mark: 3 posts Mark Kirkwood: 3 posts Ozer, Pam: 3 posts Scott Marlowe: 3 posts
show more
Archives