Search Discussions

19 discussions - 197 posts

  • Hi everyone, We have a production database (postgresql 9.0) with more than 20,000 schemas and 40Gb size. In the past we had all that information in just one schema and pg_dump used to work just fine ...
    Hugo <Nabble>Hugo <Nabble>
    May 24, 2012 at 7:07 am
    Nov 14, 2012 at 3:56 am
  • Hello, I've heard from some people that synchronous streaming replication has severe performance impact on the primary. They said that the transaction throughput of TPC-C like benchmark (perhaps ...
    May 9, 2012 at 1:07 pm
    May 11, 2012 at 1:21 pm
  • Hi, ¿How I can recover a row delete of a table that wasn't vacuummed? I have PostgreSQL 9.1 in Windows XP/7. Thanks
    Alejandro CarrilloAlejandro Carrillo
    May 28, 2012 at 6:24 pm
    Jun 4, 2012 at 6:46 pm
  • Dear List , We are having scalability issues with a high end hardware The hardware is CPU = 4 * opteron 6272 with 16 cores ie Total = 64 cores. RAM = 128 GB DDR3 Disk = High performance RAID10 with ...
    Rajesh Kumar. MallahRajesh Kumar. Mallah
    May 24, 2012 at 3:39 am
    May 24, 2012 at 9:30 pm
  • We are having trouble with a particular query being slow in a strange manner. The query is a join over two large tables that are suitably indexed. select CG.ID, CG.ISSUEID, CG.AUTHOR, CG.CREATED, ...
    Trevor CampbellTrevor Campbell
    May 31, 2012 at 10:30 pm
    Jul 18, 2012 at 7:33 pm
  • Hi All, Is there any max limit set on sequences that can be created on the database ? Also would like to know if we create millions of sequences in a single db what is the downside of it. Regards ...
    Vidhya BondreVidhya Bondre
    May 11, 2012 at 10:50 am
    May 25, 2012 at 3:04 pm
  • Hello, all. We've reached to the point when we would like to try SSDs. We've got a central DB currently 414 GB in size and increasing. Working set does not fit into our 96GB RAM server anymore. So, ...
    Віталій ТимчишинВіталій Тимчишин
    May 15, 2012 at 3:21 pm
    May 28, 2012 at 12:14 pm
  • Hi, I am using postgresql as database for a hibernate based java oltp project and as in previous projects am totally impressed by postgresql's robustness, performance and feature-richness. Thanks for ...
    Clemens EissererClemens Eisserer
    May 1, 2012 at 2:34 pm
    May 24, 2012 at 6:25 am
  • Hello, I have a SQL function (which I've pasted below) and while testing its code directly (outside a function), this is the "normal", default plan: http://explain.depesz.com/s/vfP (67 ms) and this ...
    Ivan VorasIvan Voras
    May 26, 2012 at 9:39 pm
    Jun 8, 2012 at 11:01 am
  • Hi, we want to see if we can gain better performance with our postgresql database. In the last year the amount of data growed from ~25G to now ~140G and we're currently developing a new feature that ...
    Martin GrotzkeMartin Grotzke
    May 2, 2012 at 1:19 pm
    May 7, 2012 at 9:37 am
  • hi all - i'm having a bit of trouble with some queries that are running painfully slowly after migrating my database from one machine using PostgreSQL 8.2 to another machine with PostgreSQL 8.4. as ...
    Murat TasanMurat Tasan
    May 30, 2012 at 5:57 pm
    Jun 1, 2012 at 3:15 pm
  • Hello, I'm wondering if there is ia document describing which guarantees (if any) PostgreSQL makes about concurrency for various operations? Speaking in general (i.e. IO can handle it, number of CPU ...
    Ivan VorasIvan Voras
    May 25, 2012 at 10:05 pm
    May 25, 2012 at 11:57 pm
  • Hi, I'm fairly new to PostgreSQL query tuning, so please forgive me if I've overlooked something obvious. I have a query which is running slowly, and the query plan shows an unexpected sequence scan ...
    Dan FairsDan Fairs
    May 4, 2012 at 2:24 pm
    May 4, 2012 at 2:56 pm
  • This is outside of PG performance proper, but while testing pg_dump and pg_restore performance on local-storage versus SAN storage I noticed a big performance drops on in the SAN configuration. I'm ...
    Jan NielsenJan Nielsen
    May 21, 2012 at 2:17 pm
    May 21, 2012 at 3:50 pm
  • Hi, I'm seeing poor query performance using partitioned tables with check constraints, seems like the plan is much worse than when querying the individual partitions manually. select version(); -- ...
    Richard JonesRichard Jones
    May 4, 2012 at 3:01 pm
    May 4, 2012 at 5:00 pm
  • Hello, i use PostgreSQL 8.4.8 on Centos 5.x and i have some table where i load with pg_bulkload webtraffic logs, every day. After loading new data, i delete with a query 30-days older logs ...
    May 29, 2012 at 2:54 pm
    May 29, 2012 at 5:43 pm
  • I was thinking the same thing, setting up a new server with ssds instead of hdds as I currently have and was wondering what the thoughts are in regards to using raid (it would probably be a dell R710 ...
    John ListerJohn Lister
    May 15, 2012 at 9:10 pm
    May 15, 2012 at 9:52 pm
  • This is somewhat disturbing. I need to throw out a question I hope for an answer. Has anyone ever witnessed similar behavior with a large number of relations? Slow? Corruption? -Greg
    Greg SpiegelbergGreg Spiegelberg
    May 25, 2012 at 3:52 pm
    May 25, 2012 at 3:52 pm
  • <p Learn how to make as much as $500 each day using a groundbreaking system<br <a href="http://www.info-guard.cba.pl/newsjournal/23StuartStewart/" ...
    Jessica RichardJessica Richard
    May 12, 2012 at 1:01 pm
    May 12, 2012 at 1:01 pm
Group Navigation
period‹ prev | May 2012 | next ›
Group Overview
grouppgsql-performance @

58 users for May 2012

Merlin Moncure: 16 posts Tom Lane: 14 posts Robert Klemme: 13 posts Claudio Freire: 9 posts Jan Nielsen: 9 posts Jeff Janes: 9 posts Tatsuo Ishii: 8 posts Craig James: 6 posts Rajesh Kumar. Mallah: 6 posts Clemens Eisserer: 5 posts MauMau: 5 posts Walker, James Les: 5 posts Alejandro Carrillo: 4 posts Bruce Momjian: 4 posts Hugo <Nabble>: 4 posts Ivan Voras: 4 posts Robert Haas: 4 posts Stephen Frost: 4 posts Thomas Kellerer: 4 posts David Boreham: 3 posts
show more