Search Discussions

27 discussions - 199 posts

  • 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 JamesCraig James
    Aug 20, 2012 at 11:32 pm
    Aug 21, 2012 at 9:07 pm
  • 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 KumarJ Ramesh Kumar
    Aug 16, 2012 at 3:23 am
    Aug 16, 2012 at 9:17 pm
  • 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 PettusChristophe Pettus
    Aug 14, 2012 at 1:15 am
    Aug 20, 2012 at 5:47 pm
  • 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 JamesCraig James
    Aug 7, 2012 at 6:48 pm
    Aug 11, 2012 at 2:16 pm
  • 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 MarlinJoseph Marlin
    Aug 10, 2012 at 6:45 pm
    Aug 23, 2012 at 2:43 pm
  • 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 AnagnostopoulosIoannis Anagnostopoulos
    Aug 6, 2012 at 3:08 pm
    Aug 7, 2012 at 5:42 pm
  • 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 SchubertFelix Schubert
    Aug 25, 2012 at 12:07 pm
    Sep 10, 2012 at 9:06 pm
  • 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 ShiriLiron Shiri
    Aug 26, 2012 at 12:51 pm
    Aug 30, 2012 at 8:40 am
  • 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 HunleyDoug Hunley
    Aug 14, 2012 at 3:27 pm
    Aug 16, 2012 at 4:16 pm
  • 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 KellerStefan Keller
    Aug 7, 2012 at 12:01 pm
    Aug 9, 2012 at 4:17 pm
  • 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 OttenRick Otten
    Aug 21, 2012 at 6:35 pm
    Aug 22, 2012 at 2:04 pm
  • 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ćStrahinja Kustudić
    Aug 10, 2012 at 10:16 pm
    Aug 18, 2012 at 8:01 am
  • 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 KeaneRussell Keane
    Aug 2, 2012 at 2:55 pm
    Aug 3, 2012 at 3:58 pm
  • 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 InnerebnerMarkus Innerebner
    Aug 30, 2012 at 8:11 am
    Aug 31, 2012 at 7:28 am
  • 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 MJayadevan M
    Aug 27, 2012 at 12:37 pm
    Sep 3, 2012 at 8:35 am
  • 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±cArtur Zaj±c
    Aug 24, 2012 at 6:46 pm
    Sep 1, 2012 at 2:12 am
  • 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 ThomasShaun Thomas
    Aug 24, 2012 at 4:20 pm
    Aug 25, 2012 at 2:39 pm
  • 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 AcostaAnibal David Acosta
    Aug 16, 2012 at 8:34 pm
    Aug 16, 2012 at 9:39 pm
  • 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 BrownMidge Brown
    Aug 4, 2012 at 12:38 am
    Aug 6, 2012 at 6:37 pm
  • 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 GeogheganPeter Geoghegan
    Aug 2, 2012 at 6:02 pm
    Oct 8, 2012 at 12:38 pm
  • 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 SatamNimesh Satam
    Aug 28, 2012 at 4:33 am
    Aug 28, 2012 at 6:54 am
  • 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 DawMatt Daw
    Aug 21, 2012 at 10:57 pm
    Aug 23, 2012 at 1:32 pm
  • 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 ...
    Aug 3, 2012 at 9:14 am
    Aug 9, 2012 at 12:18 am
  • 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 NagyLaszlo Nagy
    Aug 3, 2012 at 5:21 pm
    Aug 3, 2012 at 6:40 pm
  • 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 ZutterMathieu De Zutter
    Aug 28, 2012 at 7:40 am
    Aug 28, 2012 at 1:27 pm
  • 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 KaseraRajiv Kasera
    Aug 6, 2012 at 5:39 am
    Aug 8, 2012 at 6:50 am
  • 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 PresleyAnthony Presley
    Aug 11, 2012 at 2:23 pm
    Aug 11, 2012 at 2:23 pm
Group Navigation
period‹ prev | Aug 2012 | next ›
Group Overview
grouppgsql-performance @

61 users for August 2012

Jeff Janes: 19 posts Scott Marlowe: 16 posts Merlin Moncure: 12 posts Tom Lane: 11 posts Joshua Berkus: 9 posts Craig James: 8 posts Kevin Grittner: 7 posts Bruce Momjian: 5 posts Daniel Farina: 5 posts Ioannis Anagnostopoulos: 5 posts Craig Ringer: 4 posts Delongboy: 4 posts Felix Schubert: 4 posts Liron Shiri: 4 posts Russell Keane: 4 posts Stefan Keller: 4 posts Tomas Vondra: 4 posts Christophe Pettus: 3 posts David Barton: 3 posts Doug Hunley: 3 posts
show more