FAQ

Search Discussions

39 discussions - 335 posts

  • Have a query using a CTE that is performing very poorly. The equivalent query against the same data in an Oracle database runs in under 1 second, in Postgres it takes 2000 seconds. The ...
    David GrecoDavid Greco
    Nov 14, 2012 at 3:23 pm
    Nov 22, 2012 at 2:24 pm
  • Hello, this is my first message to this list, so sorry if this is not the right place to discuss this or if some data is missing from this message. I'll gladly send any data you request that would ...
    Rodrigo Rosenfeld RosasRodrigo Rosenfeld Rosas
    Nov 6, 2012 at 5:12 pm
    Nov 8, 2012 at 3:44 pm
  • Regards, Petr. Tuning PostgreSQL is not just change the postgresql.conf, it includes more things like: - the filesystem that you are using - the kernel version that you using (particularly in Linux ...
    Marcos OrtizMarcos Ortiz
    Nov 1, 2012 at 7:41 pm
    Nov 9, 2012 at 5:53 pm
  • Hi, i have these update queries, that run very often, and takes too long time, in order for us to reach the throughput we are aiming at. However, the update query is very simple, and I can't figure ...
    Niels Kristian SchjødtNiels Kristian Schjødt
    Nov 28, 2012 at 12:57 pm
    Dec 3, 2012 at 9:37 am
  • I need to delete about 1.5 million records from a table and reload it in one transaction. The usual advice when loading with inserts seems to be group them into transactions of around 1k records ...
    Mike BlackwellMike Blackwell
    Nov 27, 2012 at 10:04 pm
    Dec 12, 2012 at 5:01 pm
  • I'm probably beating a dead horse ... but isn't this just a hint? Except that it's worse than a hint, because it's a hint in disguise and is undocumented. As far as I can tell, there's no use for ...
    Craig JamesCraig James
    Nov 21, 2012 at 1:35 am
    Nov 28, 2012 at 2:26 am
  • To: David Greco Cc: <span class="m_body_email_addr" title="738cd7b1c40c7b0771f5aae66f6f02d2" pgsql-performance@postgresql.org</span Subject: Re: [PERFORM] Poor performance using CTE First, please ...
    David GrecoDavid Greco
    Nov 14, 2012 at 4:18 pm
    Nov 24, 2012 at 12:22 am
  • I was working on a data warehousing project where a fair number of files could be COPY'd more or less directly into tables. I have a somewhat nice machine to work with, and I ran on 75% of the cores ...
    Jon NelsonJon Nelson
    Nov 13, 2012 at 7:14 pm
    Nov 14, 2012 at 10:06 pm
  • I'm bringing up a new type of server using Intel E5-2620 (unisocket) which was selected for good SpecIntRate performance vs cost/power (201 for $410 and 95W). Was assuming it was 6-core but I just ...
    David BorehamDavid Boreham
    Nov 7, 2012 at 3:31 am
    Nov 9, 2012 at 2:34 pm
  • We have a web application where we create a schema or a database with a number of tables in it for each customer. Now we have about 2600 clients. The problem we met using a separate DB for each ...
    DenisDenis
    Nov 8, 2012 at 9:36 am
    Nov 15, 2012 at 3:49 pm
  • Hi, I'm on the hunt for some solid knowledge on a theoretical level about the performance of postgresql. My question is regarding best practices, and how architectural decisions might influence the ...
    Niels Kristian SchjødtNiels Kristian Schjødt
    Nov 28, 2012 at 12:41 pm
    Nov 28, 2012 at 6:05 pm
  • I have database with few hundred millions of rows. I'm running the following query: select * from "Payments" as p inner join "PaymentOrders" as po on po."Id" = p."PaymentOrderId" inner join "Users" ...
    David PopiashviliDavid Popiashvili
    Nov 16, 2012 at 11:40 am
    Nov 16, 2012 at 4:53 pm
  • Hi, I had installed postgreSQL v9.2 in Windows XP SP3. My PC specs: Processor: Pentium Dual Core 2.09 GHz RAM: 2GB The postgreSQL is run as windows service (manual). The problem is the postgreSQL ...
    Wu MingWu Ming
    Nov 12, 2012 at 2:17 pm
    Nov 14, 2012 at 12:05 pm
  • Hello, I have this table definition: CREATE TABLE ism_floatvalues ( id_signal bigint NOT NULL, -- Indica la señal a la que pertenece este valor. Clave foránea que referencia al campo id_signal de la ...
    Pedro Jiménez PérezPedro Jiménez Pérez
    Nov 2, 2012 at 12:13 pm
    Nov 6, 2012 at 3:12 pm
  • Dear All I am currently implementing using a compressed binary storage scheme genotyping data. These are basically vectors of binary data which may be megabytes in size. Our current implementation ...
    Eildert GroeneveldEildert Groeneveld
    Nov 12, 2012 at 10:45 am
    Nov 22, 2012 at 9:28 am
  • This query is a couple orders of magnitude slower the first result is 9.2.1, the second 9.1 =# explain analyze SELECT note_sets."id" AS t0_r0, note_sets."note_set_source_id" AS t0_r1, ...
    Dave CramerDave Cramer
    Nov 12, 2012 at 7:49 pm
    Nov 15, 2012 at 7:21 pm
  • Hello, I know I need to re-engineer this so it doesn't suck by design, so I'm wondering if there is some nifty PostgreSQL feature or best practice which may automagically do the best thing. I store ...
    Ivan VorasIvan Voras
    Nov 7, 2012 at 3:22 pm
    Nov 7, 2012 at 4:48 pm
  • Hi, I've just been benchmarking a new box I've got and running pgbench yields what I thought was a slow tps count. It is dificult to find comparisons online of other benchmark results, I'd like to ...
    John ListerJohn Lister
    Nov 28, 2012 at 6:37 pm
    Dec 4, 2012 at 4:28 pm
  • Hi, I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes. Data size is around 100 GB and I have tuned my PostgreSQL accordingly still I am facing performance issues. The query ...
    Syed Asif TanveerSyed Asif Tanveer
    Nov 27, 2012 at 7:47 am
    Nov 28, 2012 at 12:29 am
  • Hi, I have a table which contains generated static data (defined below) where the search_key field contains varying length strings. There are 122,000 rows in the table When the data is created the ...
    Russell KeaneRussell Keane
    Nov 16, 2012 at 2:28 pm
    Nov 16, 2012 at 3:41 pm
  • Hi list. I've been battling with a design issue here. I have postgres 9.0.x deployed in some databases, and was designing some changes that involve querying in a very partition-like way, but not ...
    Claudio FreireClaudio Freire
    Nov 2, 2012 at 6:17 pm
    Nov 5, 2012 at 8:28 pm
  • Hi, This folde( Temporary tablespace) is getting filled and size increases in the day where there lots of sorting operations.But after some times the data in the is deleted automatically . Can any ...
    Suhas.basavaraj12Suhas.basavaraj12
    Nov 28, 2012 at 6:45 am
    Nov 28, 2012 at 10:28 am
  • Hi All I am facing query performance in one of my testing server. How i can create index with table column name ? EXPLAIN select xxx.* from xxx xxx where exists (select 1 from tmp where ...
    K P ManojK P Manoj
    Nov 12, 2012 at 7:31 am
    Nov 12, 2012 at 9:44 am
  • You are using prepared statements, this makes me think that this regression might be due to support for parameter specific plans for prepared statements. [1] Can you run the test on both versions ...
    Ants AasmaAnts Aasma
    Nov 2, 2012 at 11:28 am
    Nov 7, 2012 at 11:43 am
  • Hi, We are planning to migrate our production databases to different servers.We have around 8 servers with 8 different clusters.We are planning t shuffle databases and make them as 7 cluster and ...
    Suhas.basavaraj12Suhas.basavaraj12
    Nov 28, 2012 at 6:12 pm
    Nov 28, 2012 at 6:30 pm
  • Hi I tried to run quite simple query. For some reason query took lots of memory, more than 6GB. System start swapping, so I canceled it after 4 minutes. There were no other queries in same time. If I ...
    Antti JokipiiAntti Jokipii
    Nov 15, 2012 at 7:20 pm
    Nov 27, 2012 at 11:37 pm
  • Hi, i am running some tests to check performance between postgresql and mysql. one important issue is PQconnectdb (PQconnectStart/PQconnectPoll) against mysql_init/mysql_real_connect functions ...
    Sergio MayoralSergio Mayoral
    Nov 15, 2012 at 9:03 am
    Nov 22, 2012 at 10:35 am
  • [Please CC me on replies, as I'm not subscribed; thank you.] I've ran into a problem with the query planner and IN (subquery) conditions which I suspect to be a bug. I'll attempt to describe the ...
    Rafał RzepeckiRafał Rzepecki
    Nov 11, 2012 at 3:18 am
    Nov 12, 2012 at 8:50 pm
  • Can someone shed some light on the following query..... any help would certainly be appreciated! thanks - ***** Maria Wilson Nasa/Langley Research Center Hampton, Virginia <span ...
    Maria L. WilsonMaria L. Wilson
    Nov 15, 2012 at 3:03 pm
    Nov 20, 2012 at 1:06 pm
  • Hi, I have create table x ( att bigint, val bigint, hash varchar(30) ); with 693million rows. The query create table y as select att, val, count(*) as cnt from x group by att, val; ran for more than ...
    Oliver SeidelOliver Seidel
    Nov 8, 2012 at 11:55 am
    Nov 10, 2012 at 3:32 pm
  • where should i get the original working source code of DBT-1 bechmark and it is compatible with postgres 9.2? -- View this message in context ...
    SamratSamrat
    Nov 5, 2012 at 6:43 am
    Nov 5, 2012 at 6:46 am
  • Hello everyone, If one would create a postgres performance tool, what would one like to measure aside from the obvious things common to all databases (query times, locks etc)? I'm in the slightly ...
    Christoffer LernöChristoffer Lernö
    Nov 4, 2012 at 11:55 pm
    Nov 5, 2012 at 12:08 am
  • Hello, This is a performance question that has held me occupied for quite some time now, The following join is a somewhat slow query: (np_artikel, sm_artikel_dim are views and sm_orderrad_* are ...
    Niklas PaulssonNiklas Paulsson
    Nov 22, 2012 at 12:06 pm
    Nov 22, 2012 at 12:06 pm
  • Hi Maria, It appears to be doing a sort so that it can carry out the group by clause but the group by doesn't appear to be necessary as you're selecting the max(b.ID) after doing the group by. If you ...
    Russell KeaneRussell Keane
    Nov 20, 2012 at 11:16 am
    Nov 20, 2012 at 11:16 am
  • Postgres Performance Wizards, I am a few years into developing and operating a system underpinned by Postgres that sees the arrival a significant number of events around the clock, not an epic amount ...
    Andrew W. GibbsAndrew W. Gibbs
    Nov 18, 2012 at 5:14 pm
    Nov 18, 2012 at 5:14 pm
  • Can someone shed some light on the following query..... any help would certainly be appreciated! thanks - ***** Maria Wilson Nasa/Langley Research Center Hampton, Virginia <span ...
    Maria L. WilsonMaria L. Wilson
    Nov 15, 2012 at 3:59 pm
    Nov 15, 2012 at 3:59 pm
  • I'm running a server with lots of counts and calculations. currently its ubuntu server is freebsd faster? also this is a i386 machine. or linux and bsd is about the same. this is not to be an ...
    List, mailingList, mailing
    Nov 2, 2012 at 2:39 pm
    Nov 2, 2012 at 2:39 pm
  • Well, why wouldn't you expect it to be safe? Core extensions should be mostly assumed safe unless there is a good reasons to believe otherwise. That said, there may be some performance impacts, In ...
    Merlin MoncureMerlin Moncure
    Nov 1, 2012 at 9:26 pm
    Nov 1, 2012 at 9:26 pm
Group Navigation
period‹ prev | Nov 2012 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions39
posts335
users87
websitepostgresql.org
irc#postgresql

87 users for November 2012

Tom Lane: 24 posts Claudio Freire: 23 posts Merlin Moncure: 17 posts Jeff Janes: 15 posts Craig Ringer: 12 posts Rodrigo Rosenfeld Rosas: 12 posts Willem Leenen: 10 posts Andrew Dunstan: 9 posts Heikki Linnakangas: 9 posts Petr Praus: 9 posts Albe Laurenz: 8 posts Gunnar \"Nick\" Bluth: 8 posts Niels Kristian Schjødt: 8 posts Denis: 7 posts Gavin Flower: 7 posts Jon Nelson: 7 posts David Boreham: 6 posts Kevin Grittner: 6 posts Mike Blackwell: 6 posts Scott Marlowe: 6 posts
show more
Archives