FAQ

Search Discussions

33 discussions - 185 posts

  • [Apologies, I first sent this to the incorrect list, postgres-admin, in the event you receive it twice] Hi there, I'm hoping someone on the list can shed some light on an issue I'm having with our ...
    Armand du PlessisArmand du Plessis
    Apr 1, 2013 at 10:36 pm
    Apr 2, 2013 at 6:16 pm
  • Hi, I have query that should be quick, and used to be quick, but is not anymore... Explain analyze can be seen here http://explain.depesz.com/s/cpV but it is fundamentaly quick : Total runtime: 0.545 ...
    Franck RoutierFranck Routier
    Apr 4, 2013 at 2:48 pm
    Apr 8, 2013 at 4:46 pm
  • Hi All, Hoping someone can help me out with some performance issues I'm having with the INDEX on my database. I've got a database that has a data table containing ~55,000,000 rows which have point ...
    Mark DavidsonMark Davidson
    Apr 5, 2013 at 3:51 pm
    Apr 15, 2013 at 8:16 pm
  • I'm encountering an issue where PG 9.2.4 (we also see this with 9.2.3) is picking a plan involving a bitmap heap scan that turns out to be much slower than a nested-loop plan using indexes. The ...
    Steve SingerSteve Singer
    Apr 10, 2013 at 1:50 pm
    Apr 19, 2013 at 5:05 pm
  • Hi guys. I compiled my postrges server (9.1.4) with default segment size (16MB). Should it be enough? Should I increase this size in compilation?
    Rodrigo BarbozaRodrigo Barboza
    Apr 12, 2013 at 4:45 pm
    Apr 14, 2013 at 11:30 pm
  • So It was announced that there would be a security patch for all versions released on the 4th. I see it's been announced/released on the website, but the versions available show Feb dates. Should the ...
    Tory M BlueTory M Blue
    Apr 2, 2013 at 12:10 am
    Apr 4, 2013 at 9:11 am
  • On 9.2.4, running two identical queries except for the value of a column in the WHERE clause. Postgres is picking very different query plans, the first is much slower than the second. Any ideas on ...
    Joe Van DykJoe Van Dyk
    Apr 6, 2013 at 1:38 am
    Apr 6, 2013 at 2:44 pm
  • Hi, Could someone tell m how to measure postgres memory usage. Is there a pg_* view to measure? Thank you NikT
    Nik TekNik Tek
    Apr 7, 2013 at 4:59 am
    Apr 9, 2013 at 6:42 pm
  • Hi everybody, in a project I have a performance problem, which I (and my colleagues) don't understand. It's a simple join between 2 of 3 tables: table-1: user (id, user_name, ...). This table has ...
    Dieter RehbeinDieter Rehbein
    Apr 2, 2013 at 8:52 am
    Apr 3, 2013 at 8:50 am
  • Folks, I've heard a rumor that the most recent update of OSX "mountain lion" lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from installing. Can anyone verify this? -- Josh Berkus ...
    Josh BerkusJosh Berkus
    Apr 21, 2013 at 9:30 pm
    Apr 23, 2013 at 12:39 am
  • Hi, My databases are updated regularly so I am vacuuming frequently (every one hour). Recently i also added template1 database to avoid over wrapping problem. But somehow i am seeing strange ...
    Sunil virmaniSunil virmani
    Apr 21, 2013 at 12:46 pm
    Apr 22, 2013 at 8:26 am
  • I was investigating some performance issues and stumbled upon this behavior: create table main_table (i serial primary key, data varchar, ord int); create view main_view_order as select m.i, m.data, ...
    Rikard PavelicRikard Pavelic
    Apr 13, 2013 at 8:25 am
    Apr 14, 2013 at 10:34 am
  • Hi, What is the recommended swap space for postgres or 9.0.11 or 9.2.3 on linux(3.0.58-0.6) RAM on the hox is 32GB. Thank you Nik
    Nik TekNik Tek
    Apr 12, 2013 at 9:05 pm
    Apr 12, 2013 at 11:06 pm
  • I have a Hibernate-generated query (That's not going to change, so let's just focus on the Postgres side for now) like this: SELECT * from PERSON p where p.PERSON_ID in ( select distinct p2.PERSON_ID ...
    Mark HamptonMark Hampton
    Apr 30, 2013 at 5:13 pm
    Apr 30, 2013 at 8:03 pm
  • Hi, I am using postgresql 8.1 DB. I have a large DB and i run the vacuum every hour with "vocuumdb --analyze -a" option. Some times template1 consumes much time in comparison to my own DB.I think at ...
    Pradeep singhPradeep singh
    Apr 22, 2013 at 11:31 am
    Apr 23, 2013 at 1:49 am
  • Dear All, Can any one please help me to fix this issue, i am getting this error from our application, currently Database is running on 9.2. 2013-04-17 11:37:25:151 - {ERROR} ...
    Itishree suklaItishree sukla
    Apr 17, 2013 at 4:01 pm
    Apr 18, 2013 at 9:17 pm
  • Hello, I recently stumbled upon on what could be a planner bug or a corner case. If "<false condition OR ..." is added to WHERE clause of SELECT query, then the planner chooses a very inefficient ...
    Dmitry potapovDmitry potapov
    Apr 18, 2013 at 2:20 pm
    Apr 18, 2013 at 2:47 pm
  • Hi, (I have put the contents of this email at http://pastebin.com/6h49zrYE for better readibility) I have been circling around the following problem for a few hours and I am wondering if anyone has ...
    Brick pglistsBrick pglists
    Apr 12, 2013 at 4:51 pm
    Apr 12, 2013 at 8:38 pm
  • Hi, Could some please explain what these warnings mean in postgres. I see these messages a lot when automatic vacuum runs. 1 tm:2013-04-10 11:39:20.074 UTC db: pid:13766 LOG: automatic vacuum of ...
    Nik TekNik Tek
    Apr 10, 2013 at 9:58 pm
    Apr 12, 2013 at 6:14 am
  • Afternoon So I just realized I've been just reimporting me Postgres configs from one version to the next, since they were initially customized for my setup. Maybe from 7.x... And now on 9.2.4 Is ...
    Tory M BlueTory M Blue
    Apr 10, 2013 at 9:25 pm
    Apr 10, 2013 at 9:53 pm
  • Recently we encountered the following unhappy sequence of events: 1/ system running happily 2/ batch load into table begins 3/ very quickly (some) preexisting queries on said table go orders of ...
    Mark KirkwoodMark Kirkwood
    Apr 26, 2013 at 2:33 am
    Apr 26, 2013 at 3:20 am
  • Hi all, I have a general question about network traffic between PostgreSQL’s client and server: what determines the network bandwidth usage or data transferring rate between a client and a server ...
    Kelphet XiongKelphet Xiong
    Apr 24, 2013 at 11:56 pm
    Apr 25, 2013 at 11:26 am
  • Hi, We are seeing some overall performance degradation in our application since we installed the security release. Other commits were also done at the same time in the application so we don't know ...
    Anne RossetAnne Rosset
    Apr 22, 2013 at 4:49 pm
    Apr 22, 2013 at 5:41 pm
  • Hello all, I'm running into an issue when joining between to tables that are partitioned by month. At this point I'm leaning towards it being a bug in the planner but it could be due to something I'm ...
    Michael OknerMichael Okner
    Apr 17, 2013 at 4:59 pm
    Apr 18, 2013 at 9:42 pm
  • Our server is running postgresql 8.4.15. During day time the cpu usage always around 80%, but it's not IO bound. The swap space is looking OK also. Also we setup pgbadger and enable all logs to ...
    Bing1221Bing1221
    Apr 11, 2013 at 11:31 pm
    Apr 18, 2013 at 8:54 pm
  • Hi all, I have this simple query that has performance issue. I am assuming there is something wrong in our configuration. Can someone point me to the right direction? (our work_mem is set to 64MB) ...
    Anne RossetAnne Rosset
    Apr 15, 2013 at 9:00 pm
    Apr 15, 2013 at 9:04 pm
  • Hi all, We are working on a patch which targets the overhead of spinlock in buffer cache.In this regard, we need to exercise buffer spinlock contention on a 16 core machine. Could anyone please ...
    Atri SharmaAtri Sharma
    Apr 15, 2013 at 6:09 am
    Apr 15, 2013 at 5:54 pm
  • All, We have performance issue in Psql8.3 vacuum run. The CPU usage going 300+ and application getting slow. How do we avoid high cpu and smooth vacuum tables. Thanks in advance Palani
    Thiyagarajan, PalaniappanThiyagarajan, Palaniappan
    Apr 11, 2013 at 9:09 pm
    Apr 12, 2013 at 10:02 am
  • I've configured 2 table like this CREATE TABLE "public"."User_Statement_Pivot" ( "Email" varchar(50), "UserId" varchar(50), "ShortId" varchar(50), "LastDirectJobMailSentDateTime" int8, "What" ...
    Luigi SaggeseLuigi Saggese
    Apr 11, 2013 at 7:47 am
    Apr 11, 2013 at 2:58 pm
  • Why is the following query getting wrong estimation of rows? I am using Postgresql 9.2.1 with default_statistics_target = 100. I execute vacuum analyze each night. explain analyze SELECT entity.id AS ...
    AI RummanAI Rumman
    Apr 2, 2013 at 6:57 pm
    Apr 3, 2013 at 3:34 pm
  • Hi, We again have problems with query planer... (Ubuntu, pg 9.1) Up to now - solution was "rephrase the question", but for next thing we are not sure what would be best solution... the whole story is ...
    Misa SimicMisa Simic
    Apr 25, 2013 at 12:18 pm
    Apr 25, 2013 at 12:18 pm
  • Hi guys. I'm tuning my postgres server and I faced these 2 parameters. Today they have default values. Is default enough? How should I tune these values?
    Rodrigo BarbozaRodrigo Barboza
    Apr 19, 2013 at 9:55 pm
    Apr 19, 2013 at 9:55 pm
  • Hi guys. I read in some forums that this parameter is better to set it to something like 0.7. Mine is default (0.5) and sometime it logs the message: WARNING: pgstat wait timeout Could there be any ...
    Rodrigo BarbozaRodrigo Barboza
    Apr 12, 2013 at 9:41 pm
    Apr 12, 2013 at 9:41 pm
Group Navigation
period‹ prev | Apr 2013 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions33
posts185
users59
websitepostgresql.org
irc#postgresql

59 users for April 2013

Jeff Janes: 16 posts Armand du Plessis: 12 posts Tom Lane: 12 posts Franck Routier: 10 posts Mark Kirkwood: 9 posts Mark Davidson: 8 posts Rodrigo Barboza: 7 posts Steve Singer: 7 posts Nik Tek: 6 posts Vasilis Ventirozos: 6 posts Kevin Grittner: 5 posts Scott Marlowe: 5 posts Joe Van Dyk: 4 posts Merlin Moncure: 4 posts Tory M Blue: 4 posts Dieter Rehbein: 3 posts Greg Williamson: 3 posts Hubert depesz lubaczewski: 3 posts Ktm: 3 posts Nikolas Everett: 3 posts
show more
Archives