FAQ

PostgreSQL > pgsql-performance > August 2006

Search Discussions

58 discussions - 501 posts

  • I am do some consulting for an animal hospital in the Boston, MA area. They wanted a new server to run their database on. The client wants everything from one vendor, they wanted Dell initially, I'd ...
    Steve PoeSteve Poe
    Aug 8, 2006 at 12:24 am
    Aug 18, 2006 at 10:23 pm
  • unsubscribe -- Wade Klaver Wavefire Technologies Corporation GPG Public Key at http://archeron.wavefire.com /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ...
    Wade KlaverWade Klaver
    Aug 3, 2006 at 4:12 pm
    Aug 18, 2006 at 10:22 pm
  • Hi, We're running PostgreSQL 8.1.4 on CentOS 4 (Linux version 2.6.9-34.0.1.ELsmp). Hardware specs: 2x AMD Dual-Core Opteron 270 Italy 1Ghz HT 2 x 1MB L2 Cache Socket 940 4 GB Registered ECC PC3200 ...
    Willo van der MerweWillo van der Merwe
    Aug 29, 2006 at 2:10 pm
    Aug 30, 2006 at 4:45 pm
  • I'm exhausted to try all performance tuning ideas, like following parameters shared_buffers fsync max_fsm_pages max_connections shared_buffers work_mem max_fsm_pages effective_cache_size ...
    Marty JiaMarty Jia
    Aug 21, 2006 at 9:09 pm
    Aug 22, 2006 at 8:33 pm
  • I'm in the process of migrating a Paradox 7/BDE 5.01 database from single-user Paradox to a web based interface to either MySQL or PostgreSQL. The database is a pedigree sheep breed society database ...
    Peter HardmanPeter Hardman
    Aug 16, 2006 at 5:50 pm
    Oct 2, 2006 at 1:07 pm
  • I intend to test Postgres/Bizgres for DWH use. I want to use XFS filesystem to get the best possible performance at FS level(correct me if I am wrong !). Is anyone using XFS for storing/retrieving ...
    Milen KulevMilen Kulev
    Aug 1, 2006 at 9:50 pm
    Aug 7, 2006 at 4:55 pm
  • Hi, First of all I must tell that my reality in a southern brazilian city is way different than what we read in the list. I was lookig for ways to find the HW bottleneck and saw a configuration like: ...
    Alvaro Nunes MeloAlvaro Nunes Melo
    Aug 7, 2006 at 10:26 pm
    Aug 18, 2006 at 1:14 pm
  • Hi, We are using PostgreSQL 7.1 cygwin installed on Windows 2000 (2 GB Memory, P4). We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. The performance is very ...
    Ravindran G - TLS, Chennai.Ravindran G - TLS, Chennai.
    Aug 22, 2006 at 1:00 pm
    Aug 28, 2006 at 7:47 pm
  • Hello, I've recently been tasked with scalability/performance testing of a Dell PowerEdge 2950. This is the one with the new Intel Woodcrest Xeons. Since I haven't seen any info on this box posted to ...
    Bucky JordanBucky Jordan
    Aug 9, 2006 at 4:23 pm
    Aug 18, 2006 at 6:46 am
  • This question is related to the thread: http://archives.postgresql.org/pgsql-performance/2006-08/msg00152.php but I had some questions. I am looking at setting up two general-purpose database ...
    Jeff DavisJeff Davis
    Aug 22, 2006 at 9:34 pm
    Aug 24, 2006 at 8:29 pm
  • All, Got a little bit of a performance problem I hope that can be resolved. All the files/info I believe you are going to ask for are here: http://www.au.sorbs.net/~matthew/postgres/30.8.06/ The odd ...
    Matthew SullivanMatthew Sullivan
    Aug 30, 2006 at 10:30 am
    Aug 31, 2006 at 7:49 pm
  • Hi all, This is my first post to the performance list, I hope someone can help me. I'm setting up a table with 2 columns, both of which reference a column in another table: CREATE TABLE ...
    Sue FittSue Fitt
    Aug 10, 2006 at 8:05 am
    Aug 15, 2006 at 4:01 pm
  • Hi, We noticed a slowdown on our application while traffic was kinda heavy. The logics after reading the docs commanded us to trim the enlarged tables, run VACUUM ANALYZE and then expect fast ...
    Guillaume CottenceauGuillaume Cottenceau
    Aug 28, 2006 at 8:15 am
    Aug 28, 2006 at 4:25 pm
  • I'm trying to optimize a resume search engine that is using Tsearch2 indexes. It's running on a dual-opteron 165 system with 4GB of ram and a raid1 3Gb/sec SATA array. Each text entry is about 2-3K ...
    Carl YoungbloodCarl Youngblood
    Aug 10, 2006 at 4:00 am
    Aug 17, 2006 at 4:57 am
  • Hi, I have a query that use a function and some column test to select row. It's in the form of: SELECT * FROM TABLE WHERE TABLE.COLUMN1=something AND TABLE.COLUMN2=somethingelse AND ...
    Patrice BeliveauPatrice Beliveau
    Aug 8, 2006 at 5:49 pm
    Oct 2, 2006 at 4:08 pm
  • Hi All, I am trying to back up a full copy of one of our databases (14G) and restore it on another server. Both databases run 7.3.2 version. Though the restore completed successfully, it took 9 hours ...
    Saranya SivakumarSaranya Sivakumar
    Aug 6, 2006 at 4:54 pm
    Aug 7, 2006 at 8:07 pm
  • Hi everyone, We have a postgresql 8.1 installed on Solaris 10. It is running fine. However, for the past couple days, we have seen the i/o reports indicating that the i/o is busy most of the time. ...
    Junaili LieJunaili Lie
    Aug 28, 2006 at 11:06 pm
    Sep 28, 2006 at 12:35 pm
  • Hello, I'm migrating from MS SQL Server to PostgreSQL 8.1 and I have a serious problem: Table: APORTES - Rows: 9,000,000 (9 million) *cuiT (char 11) *cuiL (char 11) *PERI (char 6) FAMI (numeric 6) I ...
    Sebastián BaioniSebastián Baioni
    Aug 15, 2006 at 2:45 pm
    Aug 16, 2006 at 6:27 pm
  • I just put together a view, which helps us in indentifying which database tables are suffering from space bloat, ie. they take up much more space than they actually should. I though this might be ...
    Michal Taborsky - Internet MallMichal Taborsky - Internet Mall
    Aug 28, 2006 at 2:40 pm
    Aug 29, 2006 at 6:35 am
  • Hello All, This query runs forever and ever. Nature of this table being lots of inserts/deletes/query, I vacuum it every half hour to keep the holes reusable and nightly once vacuum analyze to update ...
    Subbiah, StalinSubbiah, Stalin
    Aug 23, 2006 at 1:13 am
    Aug 24, 2006 at 4:44 am
  • Good morning, I'd like to ask you some advice on pg tuning in a high concurrency OLTP-like environment. The application I'm talking about is running on Pg 8.0.1. Under average users load, iostat and ...
    Cosimo StrepponeCosimo Streppone
    Aug 31, 2006 at 4:38 pm
    Aug 31, 2006 at 6:23 pm
  • Parent table has a column say column1 which is indexed (parent table and all child tables are indexed on that column) When a select max(column1) is done on parent table..takes a very long time to get ...
    Sriram DandapaniSriram Dandapani
    Aug 24, 2006 at 11:44 pm
    Aug 25, 2006 at 3:23 pm
  • Hello, we're looking into the reason why we are getting warnings about transaction ID wraparound despite a daily "vaccumdb -qaz". Someone is claiming that VACUUM without FULL cannot reassign XIDs ...
    Marinos YannikosMarinos Yannikos
    Aug 22, 2006 at 6:33 pm
    Aug 23, 2006 at 1:24 pm
  • Hi, I am using PostgreSQL 8.1.4 for an embedded application. For some reason, vacuum is not able to identify rows that are candidates for removal (i.e., mark space as available). Background Info: I ...
    Eamonn KentEamonn Kent
    Aug 21, 2006 at 7:14 pm
    Aug 22, 2006 at 3:25 pm
  • Sorry, forgot to ask: What is the recommended/best PG block size for DWH database? 16k, 32k, 64k ? What hsould be the relation between XFS/RAID stripe size and PG block size ? Best Regards. Milen ...
    Milen KulevMilen Kulev
    Aug 1, 2006 at 10:19 pm
    Aug 4, 2006 at 8:13 pm
  • I'm at a client who's an ASP; they've written their app such that each customer gets their own database. Rigth now they're at nearly 200 databases, and were thinking that they "must be the largest ...
    Jim NasbyJim Nasby
    Aug 3, 2006 at 7:14 pm
    Aug 3, 2006 at 8:57 pm
  • Hey guys, We are running a Linux 2.4 enterprise edition box with 6GB of RAM, Postgres 8.0.3. Our applications are running on JBoss 3.2.6. We are having a Database of over 22GB in size. The problem is ...
    Indika MaligaspeIndika Maligaspe
    Aug 31, 2006 at 5:22 pm
    Sep 5, 2006 at 4:01 am
  • I'm using PostgreSQL 8.1.4 and I'm trying to force the planner to use an index. With the index, I get executions times of 0.5 seconds. Without, it's closer to 2.5 seconds. Compare these two sets of ...
    Dan LangilleDan Langille
    Aug 22, 2006 at 9:23 am
    Aug 24, 2006 at 2:43 am
  • Hello all, had an idea of optimizing a query that may work generally. In case a 'column' is indexed, following two alterations could be done I think: A) select ... where column ~ '^Foo' -- Seq Scan ...
    Ulrich HabelUlrich Habel
    Aug 22, 2006 at 5:23 pm
    Aug 22, 2006 at 9:12 pm
  • I have two simple queries that do what I believe to be the exact same thing. I was surprised to see a reliable, and what I consider to be significant (although not problematic for my application) ...
    MarkMark
    Aug 18, 2006 at 12:33 am
    Aug 18, 2006 at 2:37 am
  • Hello everyone. My (simplified) database structure is: a) table product (150000 rows) product_id BIGINT PRIMARY KEY title TEXT ... b) table action (5000 rows) action_id BIGINT PRIMARY KEY product_id ...
    Michal Taborsky - Internet MallMichal Taborsky - Internet Mall
    Aug 9, 2006 at 2:26 pm
    Aug 15, 2006 at 3:08 pm
  • Hi, I have a question with shared_buffer. Ok, I have a server with 4GB of RAM - ----- # cat /proc/meminfo MemTotal: 4086484 kB [...] - ----- So, if I want to, for example, shared_buffer to take 3 GB ...
    Ruben RubioRuben Rubio
    Aug 8, 2006 at 10:40 am
    Aug 9, 2006 at 10:37 pm
  • Postgres 8.1.4 Slony 1.1.5 Linux manny 2.6.12-10-k7-smp #1 SMP Fri Apr 28 14:17:26 UTC 2006 i686 GNU/Linux We're seeing an average of 30,000 context-switches a sec. This problem was much worse w/8.0 ...
    Donald C. Sumbry ][Donald C. Sumbry ][
    Aug 7, 2006 at 7:59 am
    Aug 7, 2006 at 7:24 pm
  • Hello, I want to ask, Is there any way to insert records from XML file to the postgres database? Please provide me some help regarding above query. Postgres version which we are using is 7.2.4 ...
    Soni deSoni de
    Aug 25, 2006 at 3:53 pm
    Aug 28, 2006 at 5:31 am
  • This did not have any takers in pgsql-general. Maybe performance-oriented folks can shed light? The basic question is if there is a way to preserve stats during pg_restore? -----Original Message----- ...
    George PavlovGeorge Pavlov
    Aug 26, 2006 at 5:13 pm
    Aug 27, 2006 at 2:38 pm
  • I am evaluating PostgreSQL as a candiate to cooperate with a java application. Performance test set up: Only one table in the database schema. The tables contains a bytea column plus some other ...
    Fredrik IsraelssonFredrik Israelsson
    Aug 24, 2006 at 9:26 am
    Aug 24, 2006 at 2:39 pm
  • Hi all, I have PostgreSQL 8.1.4 running on a P 4 2.8 GHz , 512 MB with Linux (Fedora Core 3) The SQL comands below have a performance diference that I think is not so much acceptable ( 1035.427 ms vs ...
    Luiz K. MatsumuraLuiz K. Matsumura
    Aug 16, 2006 at 1:10 am
    Aug 16, 2006 at 2:51 pm
  • Hi all, I have an application that uses PostgreSQL to store its data. The application and an instance of the database have been installed in three different locations, and none of these three ...
    Phil CairnsPhil Cairns
    Aug 10, 2006 at 10:00 am
    Aug 11, 2006 at 9:34 am
  • Hi. I'm new at using PostgreSQL. Where I work, all databases were built with MS Access. The Access files are hosted by computers with Windows 2000 and Windows XP. A new server is on its way and only ...
    Hansell baranHansell baran
    Aug 3, 2006 at 11:39 pm
    Aug 11, 2006 at 9:02 am
  • Hi, Is there any inherent benefit of using a the IN operator versus joining a temporary table? Should they offer near equal performance? It appears bitmap scan's aren't done when matching across a ...
    Rusty ConoverRusty Conover
    Aug 4, 2006 at 10:38 pm
    Aug 5, 2006 at 3:27 am
  • Hi all, I'm really glad to see all the test results people are posting here. In fact, I used info from the archives to put together our first "big" database host: -Tyan dual-core/dual-cpu mainboard ( ...
    Charles SprickmanCharles Sprickman
    Aug 22, 2006 at 8:59 pm
    Aug 28, 2006 at 4:03 pm
  • I am planning to test various filesystems on some new hardware I'm getting. Is pgbench a good way to try out the filesystem? I'm currently planning to test some or all of: Linux: ext2, ext3, XFS, ...
    Jeff DavisJeff Davis
    Aug 23, 2006 at 10:23 pm
    Aug 24, 2006 at 4:05 pm
  • Suppose, hypothetically of course, someone lacked foresight, and put a tablespace somewhere with a dumb name, like "/disk2", instead of using a symbolic link with a more descriptive name. And then ...
    Craig A. JamesCraig A. James
    Aug 23, 2006 at 1:17 am
    Aug 23, 2006 at 2:35 am
  • We're having a problem with one of our queries being slow. It appears to be due to the index being used to go from tableA to tableB. Here are the tables: CREATE TABLE tableA ( table_idA int8 NOT NULL ...
    Scott MatseasScott Matseas
    Aug 21, 2006 at 5:52 pm
    Aug 21, 2006 at 8:25 pm
  • Hello, I am trying to migrate data from a DB2 database to SQL Server 2005 database. Does anyone know about any migration tool that does that? I have heard about DB2 Migration Tool kit, but I think ...
    Contact1981Contact1981
    Aug 3, 2006 at 8:43 pm
    Aug 11, 2006 at 8:53 am
  • This isn't a bug; moving to pgsql-performance. You haven't given us nearly enough information. What kind of hardware is this? RAID? What changes have you made to postgresql.conf? -- Jim C. Nasby, Sr. ...
    Jim C. NasbyJim C. Nasby
    Aug 9, 2006 at 10:26 pm
    Aug 11, 2006 at 8:48 am
  • Hello, I have a query: explain analyze select tu.url_id, tu.url, coalesce(sd.recurse, 100), case when COALESCE(get_option('use_banner')::integer,0) = 0 then 0 else ts.use_banner end as use_banner, ...
    Eugeny N DzhurinskyEugeny N Dzhurinsky
    Aug 1, 2006 at 1:18 pm
    Aug 2, 2006 at 10:56 am
  • Hi Friends, I have one doubt in LIMIT & OFFSET clause operation. I have a table "test_limit", and it contain, SELECT * from test_limit; s_no | name ------+------------- 1 | anbarasu 8 | egambaram 12 ...
    Vanitha JayaVanitha Jaya
    Aug 29, 2006 at 7:21 am
    Aug 29, 2006 at 7:38 am
  • Hi all, I need help making the below query go faster. There are about 5 of these being done in one report. Some use joins instead of subselects but they all go about the same speed. I'm not much of a ...
    Arturo PérezArturo Pérez
    Aug 26, 2006 at 8:12 pm
    Aug 27, 2006 at 4:41 pm
  • Hi ! I'm looking for a way to change the "max_connections" parameter without restarting the PostGreSQL database. All the docs i found online are saying that this option can only be set on startup (-N ...
    Jean ArnaudJean Arnaud
    Aug 25, 2006 at 4:55 pm
    Aug 25, 2006 at 5:55 pm
Aug 2006
12
Group Navigation
period‹ prev | Aug 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions58
posts501
users117
websitepostgresql.org
irc#postgresql

117 users for August 2006

Tom Lane: 33 posts Jim Nasby: 25 posts Steve Poe: 24 posts Luke Lonergan: 23 posts Markus Schaber: 19 posts Merlin Moncure: 19 posts Joshua D. Drake: 17 posts Scott Marlowe: 16 posts Bucky Jordan: 13 posts Alvaro Herrera: 12 posts Michael Stone: 12 posts Marty Jia: 10 posts Mark: 9 posts Jeff Davis: 9 posts Willo van der Merwe: 9 posts Peter Hardman: 8 posts Vivek Khera: 8 posts Arjen van der Meijden: 7 posts Chris: 7 posts Kenji Morishige: 7 posts
show more
Archives