FAQ

Search Discussions

28 discussions - 282 posts

  • Hi, 2011/10/24 Stephen Frost <sfrost@snowman.net wrote I'd like to come back on the issue of aka of in-memory key-value database. To remember, it contains table definition and queries as indicated in ...
    Stefan KellerStefan Keller
    Feb 26, 2012 at 12:16 am
    Mar 3, 2012 at 12:30 am
  • Hi, everyone. I'm maintaining an application that exists as a "black box" in manufacturing plants. The system is based on Windows, .NET, and PostgreSQL 8.3. I'm a Unix kind of guy myself, but the ...
    Reuven M. LernerReuven M. Lerner
    Feb 23, 2012 at 8:40 am
    Feb 29, 2012 at 5:31 am
  • Per the thread from last month, I've updated the default random_page_cost on Heroku Postgres to reduce the expected cost of a random_page on all new databases. Thanks to everyone who helped come to ...
    Peter van HardenbergPeter van Hardenberg
    Feb 8, 2012 at 1:00 am
    Feb 12, 2012 at 11:37 pm
  • I have a database where I virtually never delete and almost never do updates. (The updates might change in the future but for now it's okay to assume they never happen.) As such, it seems like it ...
    Alessandro GagliardiAlessandro Gagliardi
    Feb 22, 2012 at 11:51 pm
    Mar 21, 2012 at 2:32 pm
  • Hi all, We are currently "stuck" with a performance bottleneck in our server using PG and we are thinking of two potential solutions which I would be happy to hear your opinion about. Our system has ...
    Ofer IsraeliOfer Israeli
    Feb 7, 2012 at 10:18 am
    Feb 12, 2012 at 6:32 pm
  • Hi there, We've got a pretty large table that sees millions of new rows a day, and we're trying our best to optimize queries against it. We're hoping to find some guidance on this list. Thankfully, ...
    David YeuDavid Yeu
    Feb 8, 2012 at 6:03 pm
    Feb 10, 2012 at 5:12 pm
  • I happened to be looking in the PostgreSQL logs (8.4.10, x86_64, ScientificLinux 6.1) and noticed that an app was doing some sorting (group by, order by, index creation) that ended up on disk rather ...
    Jon NelsonJon Nelson
    Feb 28, 2012 at 7:17 pm
    Feb 29, 2012 at 7:30 am
  • Hi, I have a table in Postgres like: CREATE TABLE test ( id integer, dtstamp timestamp without time zone, rating real ) CREATE INDEX test_all ON test USING btree (id , dtstamp , rating); My db has ...
    Gudmundur JohannessonGudmundur Johannesson
    Feb 1, 2012 at 5:11 pm
    Feb 7, 2012 at 7:26 pm
  • Hello all! I have a very simple query that I am trying to wrap into a function: SELECT gs.geo_shape_id AS gid, gs.geocode FROM geo_shapes gs WHERE gs.geocode = 'xyz' AND geo_type = 1 GROUP BY ...
    Steve HornSteve Horn
    Feb 18, 2012 at 2:50 pm
    Feb 20, 2012 at 5:32 pm
  • PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit Dedicated DB server 4GB ram Shared_Buffers = 1 GB Effective_cache_size = 3GB Work_mem = ...
    Kevin TrasterKevin Traster
    Feb 7, 2012 at 4:49 pm
    Feb 8, 2012 at 11:41 pm
  • Hi all, In performance testing we're doing we are currently running two scenarios: 1. Starting from an empty db, therefore all operations are INSERTs. 2. Starting from an existing db - thereby ...
    Ofer IsraeliOfer Israeli
    Feb 20, 2012 at 6:59 pm
    Feb 20, 2012 at 8:17 pm
  • Hi, Forward my question here. Best regards, Han ---------- Forwarded message ---------- From: Zhou Han <zhouhan@gmail.com Date: Wed, Feb 15, 2012 at 3:01 PM Subject: Re: [HACKERS] client performance ...
    Zhou HanZhou Han
    Feb 15, 2012 at 9:38 am
    Feb 16, 2012 at 1:45 am
  • Here's my query: SELECT foursquare.name, foursquare.city, COUNT(moment_id) AS popularity FROM foursq_categories JOIN foursquare USING (foursq_id) JOIN places USING (foursq_id) JOIN blocks USING ...
    Alessandro GagliardiAlessandro Gagliardi
    Feb 9, 2012 at 6:42 pm
    Feb 10, 2012 at 7:54 pm
  • Hello, I am trying to understand the analysis behind the "cost" attribute in EXPLAIN output. postgres = # explain select * from table_event where seq_id=8520960; QUERY PLAN ...
    Venkat BalajiVenkat Balaji
    Feb 23, 2012 at 12:21 pm
    Feb 26, 2012 at 5:23 pm
  • New question regarding this seen_its table: It gets over 100 inserts per second. Probably many more if you include every time unique_violation occurs. This flood of data is constant. The commits take ...
    Alessandro GagliardiAlessandro Gagliardi
    Feb 20, 2012 at 10:06 pm
    Feb 22, 2012 at 12:11 am
  • Comparing SELECT DISTINCT(user_id) FROM blocks JOIN seen_its USING (user_id) WHERE seen_its.created BETWEEN (now()::date - interval '8 days')::timestamp AND now()::date::timestamp to SELECT ...
    Alessandro GagliardiAlessandro Gagliardi
    Feb 17, 2012 at 6:35 pm
    Feb 20, 2012 at 9:14 pm
  • Hello all, I am trying to help the Django project by investigating if there should be some default batch size limits for insert and delete queries. This is realted to a couple of tickets which deal ...
    Anssi KääriäinenAnssi Kääriäinen
    Feb 29, 2012 at 10:16 am
    Mar 2, 2012 at 12:48 pm
  • Hi all, We have a 4-columned table that is also split up into a TOAST table, where the TOASTed entries are ~35KB each. The table size is 10K records. The table is updated at a rate of ~100 updates a ...
    Ofer IsraeliOfer Israeli
    Feb 8, 2012 at 7:34 pm
    Feb 29, 2012 at 6:45 pm
  • I found in a production system that mostly the performance is being crippled by the handling of one particular case. I hope I've reduced this to a minimal example, below. Summary: when more than one ...
    Mark HillsMark Hills
    Feb 26, 2012 at 2:17 pm
    Feb 28, 2012 at 12:17 am
  • Do you see any performance difference between the following approaches? The assumption is that most of the rows in the query will be requested often enough. 1. SQL function. CREATE OR REPLACE ...
    Igor SchteinIgor Schtein
    Feb 29, 2012 at 8:38 pm
    Apr 3, 2012 at 2:30 pm
  • Hello, I have quite systematically better performance with the text search when I disable the statistics collection for the tsvector column. So I wonder if such statistics ever make sense. Here a ...
    Marc MaminMarc Mamin
    Feb 6, 2012 at 11:05 am
    Feb 29, 2012 at 8:42 pm
  • We are experiencing an unusual slowdown when using UUID field in JOIN when updating a table. SQL looks like this: UPDATE dst SET data_field = src.data_field FROM src WHERE dst.uuid_field = ...
    CherioCherio
    Feb 24, 2012 at 10:46 pm
    Feb 27, 2012 at 3:25 pm
  • hi all In my query I have two tables (edges 3,600,000 tuples and nodes 1,373,00 tuples), where I want to obtain all edges,whose target vertex is within a given euclidean range starting from a query ...
    Markus InnerebnerMarkus Innerebner
    Feb 15, 2012 at 10:40 pm
    Feb 16, 2012 at 6:54 am
  • Hi all, I've been running a lot of benchmarks recently (I'll publish the results once I properly analyze them). One thing I'd like to demonstrate is the effect of direct I/O when the wal_fsync_method ...
    Tomas VondraTomas Vondra
    Feb 4, 2012 at 11:25 pm
    Feb 8, 2012 at 3:13 am
  • On PostgreSQL 9.1.1, I'm experiencing extremely slow/inefficient min/max queries against a partitioned table, despite the recent improvements made in version 9.1. I haven't seen this issue discussed ...
    McGehee, RobertMcGehee, Robert
    Feb 29, 2012 at 5:32 pm
    Mar 2, 2012 at 7:31 pm
  • Hi All, I am trying to compile Postgres Source code for ARM cortex A8 architecture. While compiling, I got an error message which read "selected processor does not support `swpb r4,r4,[r3]' " One of ...
    Jayashankar K BJayashankar K B
    Feb 23, 2012 at 8:14 pm
    Feb 23, 2012 at 8:20 pm
  • Hello, I'm working on a system that detects changes in someone's filesystem. We first scan the entire filesystem which is dumped into the table 'filesystem' containing the full_path of every file and ...
    Gabriel BiberianGabriel Biberian
    Feb 15, 2012 at 6:34 pm
    Feb 15, 2012 at 7:12 pm
  • I created a table with two columns: an id SERIAL (primary key) and a text (not null), and then added a unique index on the text field. Then I ran the following query (with a huge work_mem - 20GB): ...
    Jon NelsonJon Nelson
    Feb 2, 2012 at 5:28 pm
    Feb 2, 2012 at 8:59 pm
Group Navigation
period‹ prev | Feb 2012 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions28
posts282
users71
websitepostgresql.org
irc#postgresql

71 users for February 2012

Alessandro Gagliardi: 23 posts Claudio Freire: 20 posts Tom Lane: 17 posts Ofer Israeli: 15 posts Jeff Janes: 11 posts Peter van Hardenberg: 10 posts Stefan Keller: 10 posts Andy Colson: 9 posts Kevin Grittner: 9 posts Merlin Moncure: 9 posts Reuven M. Lerner: 9 posts Scott Marlowe: 9 posts Shaun Thomas: 8 posts Robert Haas: 7 posts Steve Crawford: 6 posts Tomas Vondra: 6 posts Gudmundur Johannesson: 5 posts Jon Nelson: 5 posts Joshua Berkus: 5 posts Zhou Han: 5 posts
show more
Archives