[GENERAL] Running queries to fetch a count of hits in DB on several things

he.org/solr/ Thanks, ________ Brendan Duddridge | CTO | 403-277-5591 x24 | bren...@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Jan 16, 2009, at 10:41 AM, Mohamed wrote: Hi, this

Re: [GENERAL] can't reindex a couple of tables

Hi Jim, I must have had a corrupt index as vacuum analyze verbose came back with an error and crapped out the postgres instance. Once I re- indexed the problem went away. This issue hasn't returned since re- indexing. Thanks, brendan duddridge | CTO | 403-520-5793 x24 | [EMAIL PROT

Re: [GENERAL] GUI Interface

You should try the new MacBook Jim! The 17" is out now. I used to have the 17" PB G4, but now I have a 15" MacBook Pro with 2GB of RAM. It's a sweet machine! Very fast too. ________ Brendan Duddridge | CT

Re: [GENERAL] GUI Interface

7;t know how many of those use PostgreSQL. Lots of them seem to like MySQL. We use Mac OS X exclusively for development and deployment. We use a variety of GUI and non-gui (psql) tools. PgAdmin and Navicat mostly. Thanks, ______

[GENERAL] can't reindex a couple of tables

ion to hang until I cancel the reindex command. Reindexing other tables works fine. Are these two tables corrupt or something? Is there a way to fix them? I thought about dumping them and re-loading them, but I don't know how to do that due to all the referential integrity issues from

Re: [GENERAL] can't reindex a couple of tables

Hi Tom, There must have been something like that because when we stopped and started postgres again, it worked. Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite

[GENERAL] can't reindex a couple of tables

t Postgres connection to hang until I cancel the reindex command.Reindexing other tables works fine.Are these two tables corrupt or something? Is there a way to fix them? I thought about dumping them and re-loading them, but I don't know how to do that due to all the referential integrity issues

[GENERAL] invalid memory alloc request size 1684370054

Hello,Today in our logs we received the following exception:Exception Message: EvaluateExpression failed: update category_product set product_is_active = p.is_active, product_status_code = p.status_code from product p where category_product.product_id = p.product_id  and category_id = 1001415;Next

Re: [GENERAL] page is uninitialized?

dates the table. Thanks, ________ Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Apr 19, 2006, at 9:02 AM,

Re: [GENERAL] page is uninitialized?

] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB  T2G 0V9 http://www.clickspace.com  On Apr 19, 2006, at 2:23 AM, Brendan Duddridge wrote:Hi,Shortly after posting this message, I received the following error also:PANIC:  right sibling is not next child in

Re: [GENERAL] page is uninitialized?

1 x24 |  [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB  T2G 0V9 http://www.clickspace.com  On Apr 19, 2006, at 2:16 AM, Brendan Duddridge wrote:Hi,I was doing a vacuum analyze verbose on my database today and I noticed the following message printed out:WAR

[GENERAL] page is uninitialized?

Hi,I was doing a vacuum analyze verbose on my database today and I noticed the following message printed out:WARNING:  relation "category_product" page 128979 is uninitialized --- fixingWARNING:  relation "category_product" page 128980 is uninitialized --- fixingWARNING:  relation "category_product

Re: [GENERAL] Weird error updating table

the database on nitro1.1 and the pg_xlog on nitro1.2 So there's plenty of room. We're on Mac OS X Tiger Server 10.4.6. Thanks, ________ Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive

[GENERAL] Weird error updating table

Hi,Today we received a very odd error from our PostgreSQL database:"update category_product set product_is_active = p.is_active, product_status_code = p.status_code from product p where category_product.product_id = p.product_id  and category_id = 1001415;">:    Next exception:SQL State:XX000 -- er

Re: [GENERAL] PostgreSQL makes me lie

Excellent. I've just downloaded citext and I'll try it out. Are there any problems with it? It seems like this should just be added as a default data type to PostgreSQL. Thanks, ________ Brendan Duddridge | CTO | 403-27

Re: [GENERAL] PostgreSQL makes me lie

ueries like: select * from test where lower(column1) like lower('SOme ValUe%'); Any ideas if better collation support is in the plans for future versions of PostgreSQL? Thanks, ____ Brendan Duddridge | CTO | 403-277-5

Re: [GENERAL] WAL Archiving frequency

Thanks Tom, I just didn't know if that was normal or not. I actually saw 4 WAL files / minute today. I set checkpoint_segments = 128, so maybe that will help. Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [

[GENERAL] WAL Archiving frequency

Hi,I've setup WAL file archiving to my SAN storage over the network (using an NFS mount to the file server).I've noticed that it's archiving the 16 MB wal files about once every minute. Is this normal? There's a huge number of files in my wal_archives directory now.Is there a parameter to tell it n

[GENERAL] Indexes on array columns

Hi,Is it possible to put an index on an array column?Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 |  [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB  T2G 0V9 http://www.clickspace.c

Re: [GENERAL] Clustered PostgreSQL

Do you know if pgcluster will work with PostgreSQL 8.1.3? Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http

Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

hanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Mar 4, 2006, at 8:46 PM, Andrew L. Gould wrote: On Sat, 4 Mar 2006 19:34:49 -0800 Steve Atkins <[EMAIL P

Re: [GENERAL] a web framework for postgresql?

We also use WebObjects with PostgreSQL and it's awesome as a web development framework. We have it deployed on Solaris and OS X Server. Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Intera

[GENERAL] Same data, different results in Postgres vs. FrontBase

Hi,I have a query that returns 569 rows in FrontBase, but only 30 rows in Postgres. The data is the same as I just finished copying my entire database over from FrontBase to Postgres.I've reduced my problem to the following statement and have discovered that FrontBase returns null rows along with t

Re: [GENERAL] indexes for ILIKE

We tried this recently. You have to use lower(a) like lower(b) for the index to work. Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB

Re: [GENERAL] Postgres 8.1 for Mac

We use the instructions at http://www.keyvaluecoding.com Works great. Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http

Re: [GENERAL] Plans for 8.2?

good, but it's apparently far off from reality. What's the best solution that would work on OS X Server? Thanks, ________ Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 2

Re: [GENERAL] Improving Availability

Hi Guido / Richard / Scott, What about Sequoia? Is that better or worse than pgpool? Thanks Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary

[GENERAL] Fast FrontBase to PostgreSQL converter?

Hello,Does anyone know a fast way to convert a FrontBase 4.1.16 database to a PostgreSQL 8.1 database? I have a java program that does it, but I was hoping there would be something faster. Last time I converted a database with it, it took quite a few hours. I have a production system that I need to