FAQ

Search Discussions

26 discussions - 183 posts

  • Hello there, I am having performance problem with new DELL server. Actually I have this two servers Server A (old - production) ----------------- 2xCPU Six-Core AMD Opteron 2439 SE 64GB RAM Raid ...
    Cesar MartinCesar Martin
    Apr 3, 2012 at 12:21 pm
    Apr 16, 2012 at 5:48 pm
  • I'm a n00b [1] to tuning DBs so if anyone has a bit of time to provide feedback, I'd sure appreciate any input the community might have on the plan, configuration, etc. I could very well have ...
    Jan NielsenJan Nielsen
    Apr 24, 2012 at 2:57 am
    May 24, 2012 at 5:00 am
  • hi, i had a stored procedure in ms-sql server. this stored procedure gets a parameter (account-id), dose about 20 queries, fills some temporary tables, and finally, returns a few result-sets. this ...
    Eyal WildeEyal Wilde
    Apr 11, 2012 at 10:12 pm
    May 9, 2012 at 12:53 pm
  • I'm trying to benchmark Postgres vs. several other databases on my workstation. My workstation is running 64 bit Windows 7. It has 12 gb of RAM and a W3550 @ 3 Ghz. I installed Postgres 9.1 using the ...
    Walker, James LesWalker, James Les
    Apr 30, 2012 at 1:50 pm
    May 1, 2012 at 9:47 pm
  • Hi all: Can someone please guide me as to how to solve this problem? If this is the wrong forum, please let me know which one to post this one in. I am new to Postgres (about 3 months into it) I have ...
    Venki RamachandranVenki Ramachandran
    Apr 25, 2012 at 6:52 pm
    Apr 26, 2012 at 4:13 pm
  • Hi all, We are running performance tests using PG 8.3 on a Windows 2008 R2 machine connecting locally over TCP. In our tests, we have found that it takes ~3ms to update a table with ~25 columns and ...
    Ofer IsraeliOfer Israeli
    Apr 1, 2012 at 8:25 pm
    Apr 5, 2012 at 9:40 am
  • Hi, We have recently switch our product from MS SQL 2000 to Postgresql 9.0.7. We have tuned the searches and indexes so that they are very close (often better) to what sql2k was giving us. We are ...
    Ronald Hahn, DOCFOCUS INC.Ronald Hahn, DOCFOCUS INC.
    Apr 30, 2012 at 6:32 pm
    May 8, 2012 at 9:55 am
  • Hi, i've ran into a planning problem. Dedicated PostgreSQL Server: "PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit" Memory: 8GB 4CPUs ...
    Istvan EndredyIstvan Endredy
    Apr 3, 2012 at 3:12 pm
    Apr 19, 2012 at 2:15 pm
  • Hi list! i have a table which has 8500000 rows records. i write a java program to update these records. i use 100 threads to update the records. For example, thread-1 update 1~85000 records; thread-2 ...
    Superman0920Superman0920
    Apr 4, 2012 at 3:53 pm
    Apr 10, 2012 at 1:22 pm
  • Dear list, We have a database schema, which looks the same as the attached script. When filling the tables with data, and skipping analyze on the table (so pg_stats contains no records for table ...
    Richard KojedzinszkyRichard Kojedzinszky
    Apr 24, 2012 at 8:12 am
    Apr 28, 2012 at 6:11 am
  • Hi all, OS: Linux 64 bit 2.6.32 PostgreSQL 9.0.5 installed from Ubuntu packages. 8 CPU cores 64 GB system memory Database cluster is on raid 10 direct attached drive, using a HP p800 controller ...
    Brian FehrleBrian Fehrle
    Apr 12, 2012 at 6:41 pm
    Apr 18, 2012 at 4:55 pm
  • Hi All I have a query where the planner makes a wrong cost estimate, it looks like it underestimates the cost of a "Bitmap Heap Scan" compared to an "Index Scan". This it the two plans, I have also ...
    Kim HansenKim Hansen
    Apr 4, 2012 at 1:47 pm
    Apr 10, 2012 at 9:56 am
  • Hi All; I have a query that wants to update a table based on a join like this: update test_one set f_key = t.f_key from upd_temp1 t, test_one t2 where t.id_number = t2.id_number upd_temp1 has 248,762 ...
    Kevin KempterKevin Kempter
    Apr 3, 2012 at 5:30 pm
    Apr 3, 2012 at 8:43 pm
  • Hi, I would like to understand why the following query execution don't use any fulltext indexes and takes more than 300s (using lot of temporary files): EXPLAIN ANALYZE SELECT hierarchy.id FROM ...
    Benoit DelboscBenoit Delbosc
    Apr 12, 2012 at 10:09 pm
    Apr 16, 2012 at 1:12 pm
  • I know this is a very general question. But if you guys had to specify system (could be one server or cluster), with sustainable transaction rate of 1.5M tps running postgresql, what configuration ...
    Gregg JaskiewiczGregg Jaskiewicz
    Apr 5, 2012 at 3:39 pm
    May 24, 2012 at 9:25 pm
  • We just upgraded from 9.0 to 9.1, we're using the same server configuration, that has been confirmed 3 or 4 times over. Any help would be appreciated. If I remove the "ORDER BY" it gets fast again ...
    Josh TurmelJosh Turmel
    Apr 30, 2012 at 9:18 pm
    May 3, 2012 at 3:42 pm
  • An update to our system means I'm going to be rewriting every row of some large tables (20 million rows by 15 columns). In a situation like this, can auto-vacuum take care of it, or should I plan on ...
    Craig JamesCraig James
    Apr 26, 2012 at 7:49 pm
    Apr 26, 2012 at 8:11 pm
  • Hello group! I have query like this: SELECT employments.candidate_id AS candidate_id, SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* | Two:* | Three:* | Four:*'), 2)) AS ts_rank ...
    Tomek WalkuskiTomek Walkuski
    Apr 16, 2012 at 2:26 pm
    Apr 17, 2012 at 5:12 pm
  • Hello, I have an extremely bad plan for one of my colleague's query. Basically PostgreSQL chooses to seq scan instead of index scan. This is on: antabif=# select version(); version ...
    Julien CigarJulien Cigar
    Apr 5, 2012 at 11:48 am
    Apr 6, 2012 at 11:16 am
  • Here's a strange thing. Postgres 9.1.0 on a severely underpowered test machine effective_cache_size = 128M work_mem = 48M This query: WITH RECURSIVE subordinates AS ( SELECT id, originator_id FROM ...
    Claudio FreireClaudio Freire
    Apr 26, 2012 at 5:38 pm
    Apr 26, 2012 at 8:58 pm
  • Hi all, I noticed a note on the 'Priorities' wiki page[1], which talked about the need for having "a C-language function 'nice_backend(prio)' that renices the calling backend to "prio".', and ...
    Josh KupershmidtJosh Kupershmidt
    Apr 7, 2012 at 5:07 pm
    Apr 7, 2012 at 6:31 pm
  • Hi All, I am new in using postgresSQL, I now support a system that been running on postgressql. Recently I found that the database are consuming the diskspace rapidly, it starting from 9GB and it now ...
    AhchuanAhchuan
    Apr 4, 2012 at 6:59 pm
    Apr 5, 2012 at 2:38 pm
  • Howdy, What is/is there a replacement for pg_autovacuum in PG9.0+ ? I haven't had much luck looking for it in the docs. Thanks! Dave
    David KerrDavid Kerr
    Apr 4, 2012 at 1:36 am
    Apr 4, 2012 at 1:51 am
  • I can write a query to solve my requirement in any of the followings :- 1. select * from a where NOT EXISTS ( select 1 from b where a.id = b.id) union all select * from b 2. select ( case when b.id ...
    AI RummanAI Rumman
    Apr 29, 2012 at 9:27 am
    Apr 29, 2012 at 3:10 pm
  • I have a big table ~15M records called entities. I want to find top 5 entities matching "hockey" in their name. I have a Full text index built for that, which is used ...
    XlashXlash
    Apr 13, 2012 at 4:15 pm
    Apr 13, 2012 at 5:09 pm
  • Hello, lets say I have such theoretical situation: big database with a lot of tables and fields, and a lot of users with are using different queries. And the worse - I am that data base admin ;] ...
    LukasLukas
    Apr 8, 2012 at 6:31 pm
    Apr 8, 2012 at 8:36 pm
Group Navigation
period‹ prev | Apr 2012 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions26
posts183
users63
websitepostgresql.org
irc#postgresql

63 users for April 2012

Merlin Moncure: 15 posts Kevin Grittner: 13 posts Tomas Vondra: 13 posts Scott Marlowe: 12 posts Claudio Freire: 10 posts Cesar Martin: 9 posts Andrew Dunstan: 7 posts Tom Lane: 7 posts Eyal Wilde: 4 posts Istvan Endredy: 4 posts Jan Nielsen: 4 posts Kim Hansen: 4 posts Steve Crawford: 4 posts Venki Ramachandran: 4 posts Andy Colson: 3 posts Jeff Janes: 3 posts Ofer Israeli: 3 posts Thomas Kellerer: 3 posts Віталій Тимчишин: 3 posts Ants Aasma: 2 posts
show more
Archives