FAQ

PostgreSQL > pgsql-performance > July 2011

Search Discussions

34 discussions - 234 posts

  • I am doing some research that will hopefully lead to replacing a big Oracle installation with a set PostgreSQL servers. The current Oracle installations consists of multiple of RAC clusters with 8 ...
    LarsLars
    Jul 7, 2011 at 11:56 pm
    Aug 5, 2011 at 9:58 am
  • Hi, Is BBU still needed with SSD? SSD has its own cache. And in certain models such as Intel 320 that cache is backed by capacitors. So in a sense that cache acts as a BBU that's backed by capacitors ...
    AndyAndy
    Jul 18, 2011 at 1:43 am
    Jul 21, 2011 at 7:26 am
  • Hello. I've found strange behavior of my pg installation (tested both 8.4 and 9.0 - they behave same) on FreeBSD platform. In short - when some table have PK on bigint field - COPY to that table from ...
    Robert AyrapetyanRobert Ayrapetyan
    Jul 31, 2011 at 1:51 pm
    Aug 5, 2011 at 10:36 am
  • Hello, We are running a PostgreSQL 8.4 database, with two tables containing a lot ( 1 million) moderatly small rows. It contains some btree indexes, and one of the two tables contains a gin full-text ...
    Gael Le MignotGael Le Mignot
    Jul 9, 2011 at 7:49 am
    Jul 12, 2011 at 3:44 pm
  • Hi, I have a delete query taking 7.2G of ram (and counting) but I do not understant why so much memory is necessary. The server has 12G, and I'm afraid it'll go into swap. Using postgres 8.3.14. I'm ...
    Vincent dephilyVincent dephily
    Jul 7, 2011 at 2:00 pm
    Jul 8, 2011 at 1:37 pm
  • Hi list, My employer will be donated a NetApp FAS 3040 SAN [1] and we want to run our warehouse DB on it. The pg9.0 DB currently comprises ~1.5TB of tables, 200GB of indexes, and grows ~5%/month. The ...
    ChrisChris
    Jul 15, 2011 at 6:40 am
    Jul 27, 2011 at 5:01 pm
  • Hi guys, I met with the problem that when I was using WITH clause to reuse a subquery, I got a huge performance penalty because of query planner. Here are the details, the original query is EXPLAIN ...
    Li JinLi Jin
    Jul 28, 2011 at 9:06 pm
    Aug 3, 2011 at 5:30 pm
  • I have 2 small servers, one a fairly new server with a x3450 (4-core with HT) cpu running at 2.67GHz and an older E5335 (4-core) cpu running at 2GHz. I have been quite surprised how the E5335 ...
    M. D.M. D.
    Jul 18, 2011 at 7:48 pm
    Jul 19, 2011 at 5:05 am
  • All: Was curious if there was some sort of Open Source version of Infinite Cache, and/or a memcache layer that can be "dropped" in front of PostgreSQL without application changes (which seems to be ...
    Anthony PresleyAnthony Presley
    Jul 1, 2011 at 2:43 pm
    Jul 8, 2011 at 1:42 pm
  • Hi, all. I have a query, looking like this: SELECT pub_date FROM tubesite_object INNER JOIN tubesite_image ON tubesite_image.object_ptr_id = tubesite_object.id WHERE tubesite_object.site_id = 8 AND ...
    Mario SplivaloMario Splivalo
    Jul 12, 2011 at 6:18 pm
    Jul 13, 2011 at 2:04 am
  • I have a query that uses ORDER BY and LIMIT to get a set of image data rows that match a given tag. When both ORDER BY and LIMIT are included for some reason the planner chooses a very slow query ...
    JonathanJonathan
    Jul 6, 2011 at 12:27 am
    Oct 15, 2011 at 10:17 pm
  • next question. I have a product table with a 'category" column that I want to maintain in a separate table. CREATE TABLE products ( product_id INTEGER DEFAULT nextval('product_id_seq'::regclass) NOT ...
    AlanAlan
    Jul 23, 2011 at 4:43 pm
    Aug 1, 2011 at 2:47 pm
  • Hello, I'm a postgres newbie and am wondering what's the best way to do this. I am gathering some data and will be inserting to a table once daily. The table is quite simple but I want the updates to ...
    AlanAlan
    Jul 12, 2011 at 7:43 am
    Aug 1, 2011 at 9:26 am
  • Hello, (Apologies if this is an obvious question. I have gone through the archives without seeing something that directly ties to this.) We are running Postgresql on a 64b RHEL5.2 64b server. "Uname ...
    D CD C
    Jul 7, 2011 at 8:23 pm
    Jul 8, 2011 at 5:12 pm
  • Dear all first of all congratulations on your greak work here since from time to time i 've found many answers to my problems. unfortunately for this specific problem i didnt find much relevant ...
    FilipposFilippos
    Jul 25, 2011 at 6:00 pm
    Aug 18, 2011 at 4:31 am
  • I have a query which seems to be taking an extraordinarily long time (many minutes, at least) when seemingly equivalent queries have different plans and execute in seconds. naturally, I'd like to ...
    Clem DickeyClem Dickey
    Jul 6, 2011 at 2:38 am
    Aug 4, 2011 at 1:55 am
  • Dear all, I am using Postgres-8.4.2 on Windows system. I have 2 databases in my postgres database ( globedatabase (21GB), urldatabase). I restore globedatabase from a .sql file on yesterday morning.I ...
    Adarsh SharmaAdarsh Sharma
    Jul 25, 2011 at 6:38 am
    Jul 25, 2011 at 6:15 pm
  • Dear all , could any one help me? when i use pgadmin to exceute a query it shows the total time for query .. such as (select * form table_name.........)query total time is for example 100 ms i want ...
    Radhya sahalRadhya sahal
    Jul 10, 2011 at 4:41 pm
    Jul 10, 2011 at 10:54 pm
  • I have run into issue where the query optimizer is choosing the wrong execution plan when I'm trying to join two large tables that have been partitioned. I would really appreciate it if someone could ...
    Anish KejariwalAnish Kejariwal
    Jul 8, 2011 at 9:36 pm
    Jul 10, 2011 at 4:06 pm
  • I know this has been discussed various times... We are maintaining a large multi tenant database where *all* tables have a tenant-id and all indexes and PKs lead with the tenant-id. Statistics and ...
    LarsLars
    Jul 10, 2011 at 9:16 pm
    Jul 15, 2011 at 9:41 pm
  • I've just copied a database from one linux machine to another. "Fast" machine is CentOS 5.5, running postgres 9.0.0 64 bit "Slow" machine is Red Hat 5.5 running postgres 9.0.2 64 bit. Here's the ...
    Matthias HowellMatthias Howell
    Jul 5, 2011 at 8:57 pm
    Jul 6, 2011 at 8:01 pm
  • Hi, I want to configure Logging of postgres in such a way that messages of different severity should be logged in different log file. eg: all ERROR message should be written in error-msg.log file ...
    Shailesh singhShailesh singh
    Jul 27, 2011 at 9:11 am
    Sep 1, 2011 at 11:51 am
  • I have a problem with poor query plan. My PostgreSQL is "PostgreSQL 8.4.8, compiled by Visual C++ build 1400, 32-bit" installed by EnterpriseDB installer on Windows 7 32 bit. Steps to reproduce: ...
    Дмитрий ВасильевДмитрий Васильев
    Jul 24, 2011 at 2:06 pm
    Jul 24, 2011 at 8:15 pm
  • Dear all , could any one help me? when i use pgadmin to exceute a query it shows the total time for query .. such as (select * form table_name.........)query total time is for example 100 ms i want ...
    Radhya sahalRadhya sahal
    Jul 10, 2011 at 4:44 pm
    Jul 10, 2011 at 10:21 pm
  • Hi, i am using libpq library and postgresql 8.4 for my linux application running on ARM with 256 MB. I am just doing: PQconnectdb(); PQexec(INSERT INTO table1 ....); (0.009661 sec.) PQexec(INSERT ...
    Sergio mayoralSergio mayoral
    Jul 7, 2011 at 3:35 pm
    Jul 10, 2011 at 4:43 pm
  • Hi, I am a Noob with db tuning and trying to analyze pg_stats_brwriter data checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | ...
    Rohan MalhotraRohan Malhotra
    Jul 29, 2011 at 1:37 pm
    Jul 29, 2011 at 3:25 pm
  • Is there any guidelines to sizing work_mem, shared_bufferes and other configuration parameters etc., with regards to very large records? I have a table that has a bytea column and I am told that some ...
    JtkellsJtkells
    Jul 7, 2011 at 2:38 pm
    Jul 29, 2011 at 12:25 am
  • Hi all, here is my postgresql configuration: "version";"PostgreSQL 9.0.3 on amd64-portbld-freebsd8.0, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD], 64-bit" "bytea_output";"escape" ...
    Svetlin ManavskiSvetlin Manavski
    Jul 15, 2011 at 12:57 pm
    Jul 15, 2011 at 5:59 pm
  • Hi, i am using libpq library and postgresql 8.4 for my linux application running on ARM with 256 MB. I am just doing: PQconnectdb(); PQexec(INSERT INTO table1 ....); (0.009661 sec.) PQexec(INSERT ...
    Sergio MayoralSergio Mayoral
    Jul 8, 2011 at 11:23 am
    Jul 9, 2011 at 12:40 am
  • I am trying to perform a bulkload of 1 crore rows using copy of row width 1000, but the transaction logs keeps getting huge space, is there a easy way to do it and avoid the transaction logs
    Shouvik basuShouvik basu
    Jul 5, 2011 at 2:42 pm
    Jul 5, 2011 at 5:41 pm
  • Dear all, How can retrieve total query run-time when i run any query with out using explain for example when i run any query such as select * from tablel1; Total query runtime: 443 ms. i want a ...
    Radhya sahalRadhya sahal
    Jul 3, 2011 at 4:14 am
    Jul 3, 2011 at 6:09 am
  • As one of the people recommending early investigation of Intel's recent 320 series drives, I've been following the news around them too. It looks like there's one serious firmware bug that shows up ...
    Greg SmithGreg Smith
    Jul 21, 2011 at 11:16 am
    Jul 21, 2011 at 11:16 am
  • Hello folks, This isn't really a problem, so much as an observation of just how much the internals have changed over the years. We've got an older version we're hoping to upgrade soon, and a ...
    Shaun ThomasShaun Thomas
    Jul 8, 2011 at 8:20 pm
    Jul 8, 2011 at 8:20 pm
  • Is there any guidelines to sizing work_mem, shared_bufferes and other configuration parameters etc., with regards to very large records? I have a table that has a bytea column and I am told that some ...
    JtkellsJtkells
    Jul 8, 2011 at 12:08 am
    Jul 8, 2011 at 12:08 am
Jul 2011
Group Navigation
period‹ prev | Jul 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions34
posts234
users71
websitepostgresql.org
irc#postgresql

71 users for July 2011

Lars hofhansl: 21 posts Kevin Grittner: 16 posts Greg Smith: 13 posts Tom Lane: 13 posts Craig Ringer: 8 posts Gael Le Mignot: 7 posts Merlin Moncure: 7 posts Radhya sahal: 6 posts Robert Haas: 6 posts Samuel Gendler: 6 posts Scott Marlowe: 6 posts Mario Splivalo: 5 posts Robert Klemme: 5 posts Vincent de Phily: 5 posts Alan: 4 posts Clem Dickey: 4 posts Florian Weimer: 4 posts Guillaume Lelarge: 4 posts Jeff Janes: 4 posts Ktm: 4 posts
show more
Archives