FAQ

Search Discussions

16 discussions - 119 posts

  • Hey guys, I suspect I'll get an answer equivalent to "the planner treats that like a variable," but I really hope not because it renders partitions essentially useless to us. This is as recent as ...
    Shaun ThomasShaun Thomas
    Jun 27, 2013 at 4:15 pm
    Jun 27, 2013 at 9:44 pm
  • Hi, postgres does a seqscan, even though there is an index present and it should be much more efficient to use it. I tried to synthetically reproduce it, but it won't make the same choice when i do ...
    Willy-Bas LoosWilly-Bas Loos
    Jun 26, 2013 at 3:45 pm
    Jun 26, 2013 at 9:35 pm
  • Hi, My pg_xlog dir has been growing rapidly the last 4 days, and my disk is now almost full (1000Gb) even though the database is only 50Gb. I have a streaming replication server running, and in the ...
    Niels Kristian SchjødtNiels Kristian Schjødt
    Jun 10, 2013 at 11:29 am
    Jun 10, 2013 at 7:12 pm
  • hello postgresql experts -- i have a strange row estimate problem, which unfortunately i have trouble reproducing for anything but very large tables which makes boiling down to a simple example ...
    BenBen
    Jun 24, 2013 at 10:18 pm
    Jun 27, 2013 at 3:48 am
  • Hello, I'm using php5.4.12 with extension=php_pgsql.dll enabled but the query that i'm trying to execute is faster on PgAdmin app. SELECT title, ts_rank_cd(vector, query) AS rank FROM links, ...
    Emrah MehmedovEmrah Mehmedov
    Jun 5, 2013 at 10:18 am
    Jun 25, 2013 at 10:15 am
  • All; I'm working with a client running PostgreSQL on a Fusion-IO drive. They have a PostgreSQL setup guide from Fusion recommending the following settings: effective_io_concurrency=0 ...
    CS DBACS DBA
    Jun 20, 2013 at 7:56 pm
    Jul 18, 2013 at 8:42 pm
  • Folks, I'm getting something really odd in 9.2.4, where the planner estimates that the selectivity of a column equal to itself is always exactly 0.5% (i.e. 0.005X). I can't figure out where this ...
    Josh BerkusJosh Berkus
    Jun 21, 2013 at 7:52 pm
    Jun 26, 2013 at 11:04 pm
  • Hello, We have a strange issue related to a prepared statement. We have two equals queries where the sole difference is in the limit. - The first is hard coded with limit 500. - The second is ...
    Ghislain ROUVIGNACGhislain ROUVIGNAC
    Jun 6, 2013 at 8:25 am
    Jun 10, 2013 at 1:59 pm
  • I'm trying to optimize a query on a partitioned table. The schema looks like this: CREATE TABLE observations( ts timestamptz NOT NULL DEFAULT now(), type text NOT NULL, subject uuid NOT NULL, details ...
    Maciek SakrejdaMaciek Sakrejda
    Jun 21, 2013 at 1:24 am
    Jun 21, 2013 at 5:08 pm
  • I have a table called contacts. It has a BIGINT owner_id which references a record in the user table. It also has a BIGINT user_id which may be null. Additionally it has a BOOLEAN blocked column to ...
    Robert DiFalcoRobert DiFalco
    Jun 2, 2013 at 7:39 pm
    Jun 3, 2013 at 2:46 pm
  • Hello all you guys, Since saturday I'm get stucked in a very strange situation: from time to time (sometimes with intervals less than 10 minutes), the server get "stucked"/"hang" (I dont know how to ...
    Rafael DomicianoRafael Domiciano
    Jun 11, 2013 at 12:48 pm
    Jul 1, 2013 at 6:06 pm
  • Hello, I understand that when the pg_stat_statements.save=true the statement statistics are saved at global/pg_stat_statements.stat. This file is read on next startup and then deleted. If there is a ...
    Sameer ThakurSameer Thakur
    Jun 19, 2013 at 12:32 pm
    Jun 20, 2013 at 4:04 am
  • Hello, Reading code documentation of pg_stat_statements it says * As of Postgres 9.2, this module normalizes query entries. Normalization * is a process whereby similar queries, typically differing ...
    Sameer ThakurSameer Thakur
    Jun 17, 2013 at 6:58 am
    Jun 19, 2013 at 10:59 am
  • Hello, If a table takes 100 MB while on disk, approximately how much space will it take in RAM/database buffer? Context - We are designing a database that will hold a couple of GBs of data. We wanted ...
    Jayadevan MJayadevan M
    Jun 25, 2013 at 4:57 am
    Jun 25, 2013 at 7:34 am
  • Hi All One of my query treating performance issue on my production server. Once i run query on my parent table with specific condition(hard coded value) its uses only proper child table and its index ...
    K P ManojK P Manoj
    Jun 13, 2013 at 7:56 am
    Jun 13, 2013 at 9:04 am
  • I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! K P Manoj has invited you to open a Gmail account. Gmail is ...
    K P ManojK P Manoj
    Jun 13, 2013 at 7:50 am
    Jun 13, 2013 at 7:50 am
Group Navigation
period‹ prev | Jun 2013 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions16
posts119
users44
websitepostgresql.org
irc#postgresql

44 users for June 2013

Shaun Thomas: 8 posts Tom Lane: 8 posts Bricklen: 7 posts Josh Berkus: 7 posts Willy-Bas Loos: 7 posts Jeff Janes: 6 posts Niels Kristian Schjødt: 6 posts Ben: 5 posts Emrah Mehmedov: 5 posts Igor Neyman: 4 posts Kevin Grittner: 4 posts Sameer Thakur: 4 posts Maciek Sakrejda: 3 posts Marcin Mańk: 3 posts Robert DiFalco: 3 posts Amit Kapila: 2 posts Andrew Dunstan: 2 posts Bob Jolliffe: 2 posts Ghislain ROUVIGNAC: 2 posts Heikki Linnakangas: 2 posts
show more
Archives