August 2012

Discussions Analytics Info

Search Discussions

27 discussions - 199 posts

Newest Active Popular

13
Does setval(nextval()+N) generate unique blocks of IDs?

Is seq.setval() "non transactional" in the same sense as seq.nextval() is? More specifically, suppose I sometimes want to get IDs one-by-one using nextval(), but sometimes I want a block of a ...

Craig James
Aug 20, 2012 at 11:32 pm
Aug 21, 2012 at 9:07 pm
13
High Disk write and space taken by PostgreSQL

Hi, My application has high data intensive operations (high number of inserts 1500 per sec.). I switched my application from MySQL to PostgreSQL. When I take performance comparison report between ...

J Ramesh Kumar
Aug 16, 2012 at 3:23 am
Aug 16, 2012 at 9:17 pm
12
7k records into Sort node, 4.5m out?

Consider this EXPLAIN ANALYZE output: http://explain.depesz.com/s/TCi Note the Bitmap Heap Scan at the bottom claims to be producing 7094 rows, and the Sort above it expects to be processing 7330 ...

Christophe Pettus
Aug 14, 2012 at 1:15 am
Aug 20, 2012 at 5:47 pm
12
Is drop/restore trigger transactional?

I found this discussion from 2005 that says you can drop and restore a trigger inside a transaction, but that doing so locks the whole table ...

Craig James
Aug 7, 2012 at 6:48 pm
Aug 11, 2012 at 2:16 pm
9
Increasing WAL usage followed by sudden drop

http://i.imgur.com/sva4H.png In the image above, please find the traffic we have seen from our main postgresql node to our cloud backup. A few notes on that image: a) We're only interested in looking ...

Joseph Marlin
Aug 10, 2012 at 6:45 pm
Aug 23, 2012 at 2:43 pm
9
Sequential scan instead of index scan

Hi, my query is very simple: select msg_id, msg_type, ship_pos_messages.pos_georef1, ship_pos_messages.pos_georef2, ship_pos_messages.pos_georef3, ship_pos_messages.pos_georef4, obj_id, ship_speed, ...

Ioannis Anagnostopoulos
Aug 6, 2012 at 3:08 pm
Aug 7, 2012 at 5:42 pm
8
Slow Performance on a XEON E5504

Hello List, I've got a system on a customers location which has a XEON E5504 @ 2.00GHz Processor (HP Proliant) It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram: The Postgres ...

Felix Schubert
Aug 25, 2012 at 12:07 pm
Sep 10, 2012 at 9:06 pm
8
Investigating the reason for a very big TOAST table size

From: Liron Shiri Sent: Sunday, August 26, 2012 3:47 PM To: '[email protected]' Subject: Investigating the reason for a very big TOAST table size Importance: High Hi, We have a table ...

Liron Shiri
Aug 26, 2012 at 12:51 pm
Aug 30, 2012 at 8:40 am
8
cluster on conditional index?

According to the docs on cluster: if you tend to access some data more than others, and there is an index that groups them together, you will benefit from using CLUSTER however, this doesn't address ...

Doug Hunley
Aug 14, 2012 at 3:27 pm
Aug 16, 2012 at 4:16 pm
8
Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m

Hi I have an interesting query to be optimized related to this one [1]. The query definition is: Select all buildings that have more than 1 pharmacies and more than 1 schools within a radius of ...

Stefan Keller
Aug 7, 2012 at 12:01 pm
Aug 9, 2012 at 4:17 pm
6
average query performance measuring

I have a PostgreSQL 9.1 cluster. Each node is serving around 1,000 queries per second when we are at a 'steady state'. What I'd like to know is the average query time. I'd like to see if query ...

Rick Otten
Aug 21, 2012 at 6:35 pm
Aug 22, 2012 at 2:04 pm
6
Index Bloat Problem

We have PostgreSQL 9.1 running on Centos 5 on two SSDs, one for indices and one for data. The database is extremely active with reads and writes. We have autovacuum enabled, but we didn't tweak it's ...

Strahinja Kustudić
Aug 10, 2012 at 10:16 pm
Aug 18, 2012 at 8:01 am
6
query using incorrect index

Using PG 9.0 and given 2 queries (messageq_current is a view on the messageq_table): select entity_id from messageq_current where entity_id = 123456; select entity_id from messageq_current where ...

Russell Keane
Aug 2, 2012 at 2:55 pm
Aug 3, 2012 at 3:58 pm
5
Question about caching on full table scans

Hello PG Performance group, I am doing some runtime experiments in my implementation, which is computing multi-modal range queries for a query point (if you want to know details check the website ...

Markus Innerebner
Aug 30, 2012 at 8:11 am
Aug 31, 2012 at 7:28 am
4
Execution from java - slow

Hello all, I have a plpgsql function that takes a few seconds (less than 5) when executed from psql. The same function, when invoked from java via a prepared statement takes a few minutes. There are ...

Jayadevan M
Aug 27, 2012 at 12:37 pm
Sep 3, 2012 at 8:35 am
4
NOTIFY performance

Hello, I would like to create some application using triggers and LISTEN/NOTIFY framework. I've tested it, and I noticed that performance of NOTIFY significally decreases with increasing number of ...

Artur Zaj±c
Aug 24, 2012 at 6:46 pm
Sep 1, 2012 at 2:12 am
4
Loose Index Scans by Planner?

Maybe I should post this in Hackers instead, but I figured I'd start here to avoid cluttering up that list. So, we know we have a way of doing a loose index scan with CTEs ...

Shaun Thomas
Aug 24, 2012 at 4:20 pm
Aug 25, 2012 at 2:39 pm
4
best practice to avoid table bloat?

Hi, if I have a table that daily at night is deleted about 8 millions of rows (table maybe has 9 millions) is recommended to do a vacuum analyze after delete completes or can I leave this job to ...

Anibal David Acosta
Aug 16, 2012 at 8:34 pm
Aug 16, 2012 at 9:39 pm
4
slow query, different plans

I'm having a problem with a query on our production server, but not on a laptop running a similar postgres version with a recent backup copy of the same table. I tried reindexing the table on the ...

Midge Brown
Aug 4, 2012 at 12:38 am
Aug 6, 2012 at 6:37 pm
2
[repost] Help me develop new commit_delay advice

This has been reposted to this list from the pgsql-hackers list, at the request of Josh Berkus. Hopefully there will be more interest here. ---------- Forwarded message ---------- From: Peter ...

Peter Geoghegan
Aug 2, 2012 at 6:02 pm
Oct 8, 2012 at 12:38 pm
2
Vacuum problems with 9.1

Hi, We have been using the current version of postgres i.e. 9.1.4 with streaming replication on. While vacuuming we noticed that certain dead rows are not getting removed and following debug ...

Nimesh Satam
Aug 28, 2012 at 4:33 am
Aug 28, 2012 at 6:54 am
2
Performance of Seq Scan from buffer cache

Howdy. I'm curious what besides raw hardware speed determines the performance of a Seq Scan that comes entirely out of shared buffers… I ran the following on the client's server I'm profiling, which ...

Matt Daw
Aug 21, 2012 at 10:57 pm
Aug 23, 2012 at 1:32 pm
2
Postgresql - performance of using array in big database

Hello Let say we have a table with 6 million records. There are 16 integer columns and few text column. It is read-only table so every integer column have an index. Every record is around 50-60 ...

Roberthanco
Aug 3, 2012 at 9:14 am
Aug 9, 2012 at 12:18 am
2
Re: [ADMIN] Messed up time zones

Yes, I know the zone. But I don't know the offset from UTC. Example: template1= set timezone to 'UTC'; SET template1= select ('2011-10-30 01:00:00'::timestamptz) at time zone 'Europe/Budapest' ...

Laszlo Nagy
Aug 3, 2012 at 5:21 pm
Aug 3, 2012 at 6:40 pm
1
pg_trgm and slow bitmap index scan plan

Hi all, I've been trying to apply pg_tgrm for the search-function of my application. The database fits a few times in the available RAM, and is mostly read-only. Plans, schema and configs in ...

Mathieu De Zutter
Aug 28, 2012 at 7:40 am
Aug 28, 2012 at 1:27 pm
1
Postgres Upgrade from 8.4 to 9.1

Hi, I am planning a Postgres migration from 8.4 to 9.1 to be able to leverage the replication features available in the 9.1 version. I would like to understand the following things in this regard ...

Rajiv Kasera
Aug 6, 2012 at 5:39 am
Aug 8, 2012 at 6:50 am
0
Improve DB Size / Performance with Table Refactoring

Hi there! We currently have a database table that's laid out something like this: id int date1 date belongs_to date type varchar(1) type_fk int start_time time end_time time location_fk int ...

Anthony Presley
Aug 11, 2012 at 2:23 pm
Aug 11, 2012 at 2:23 pm