May 2012

Discussions Analytics Info

Search Discussions

19 discussions - 197 posts

Newest Active Popular

65
pg_dump and thousands of schemas

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>
May 24, 2012 at 7:07 am
Nov 14, 2012 at 3:56 am
14
Could synchronous streaming replication really degrade the performance of the primary?

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 ...

MauMau
May 9, 2012 at 1:07 pm
May 11, 2012 at 1:21 pm
12
Recover rows deleted

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 Carrillo
May 28, 2012 at 6:24 pm
Jun 4, 2012 at 6:46 pm
12
High load average in 64-core server , no I/O wait and CPU is idle

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. Mallah
May 24, 2012 at 3:39 am
May 24, 2012 at 9:30 pm
11
Trouble with plan statistics for behaviour for query.

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 Campbell
May 31, 2012 at 10:30 pm
Jul 18, 2012 at 7:33 pm
10
Maximum number of sequences that can be created

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 Bondre
May 11, 2012 at 10:50 am
May 25, 2012 at 3:04 pm
9
SSD selection

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
9
Any disadvantages of using =ANY(ARRAY()) instead of IN?

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 Eisserer
May 1, 2012 at 2:34 pm
May 24, 2012 at 6:25 am
5
Seqscan slowness and stored procedures

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 Voras
May 26, 2012 at 9:39 pm
Jun 8, 2012 at 11:01 am
5
Several optimization options (config/hardware)

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 Grotzke
May 2, 2012 at 1:19 pm
May 7, 2012 at 9:37 am
4
does the query planner consider work_mem?

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 Tasan
May 30, 2012 at 5:57 pm
Jun 1, 2012 at 3:15 pm
3
Parallel (concurrent) inserts?

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 Voras
May 25, 2012 at 10:05 pm
May 25, 2012 at 11:57 pm
3
Unexpected sequence scan

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 Fairs
May 4, 2012 at 2:24 pm
May 4, 2012 at 2:56 pm
2
local-storage versus SAN sequential read performance comparison

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 Nielsen
May 21, 2012 at 2:17 pm
May 21, 2012 at 3:50 pm
2
Partitioned/inherited tables with check constraints causing slower query plans

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 Jones
May 4, 2012 at 3:01 pm
May 4, 2012 at 5:00 pm
1
Strong slowdown on huge tables

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 ...

Job
May 29, 2012 at 2:54 pm
May 29, 2012 at 5:43 pm
1
Re: [pgsql-performance] Daily digest v1.3606 (10 messages)

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 Lister
May 15, 2012 at 9:10 pm
May 15, 2012 at 9:52 pm
0
Millions of relations (from Maximum number of sequences that can be created)

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 Spiegelberg
May 25, 2012 at 3:52 pm
May 25, 2012 at 3:52 pm
0
[[No Subject]]

<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 Richard
May 12, 2012 at 1:01 pm
May 12, 2012 at 1:01 pm