Greg,
Thank you for the information. We are not aware about this. Please remove my
email.
We will follow the process in future.
Regards,
MS
M.S. Rao | Director
0: 608.661.7604 I ms@symphonycorp.com<mailto:ms@symphonycorp.com>
Symphony Corporation<http://www.symphonycor
, and track record of delivering high quality services to its clients.
Symphony offers very attractive compensation package with benefits for the
right candidates.
Thanks
M.S. Rao | Director
0: 608.661.7604 I ms@symphonycorp.com<mailto:ms@symphonycorp.com>
Symphony Corpo
>SIGSEGV in micro$oft world.
Thanks for your response.
How can this be resolved?
Regards
Swati
Sorry for resending, it got stalled.
Have subscribed to pgsql-general now.
>What query, exactly? Which PG version is this?
> regards, tom lane
Its a query involving 15 relations, processing not more than 500 records. The
query is written in a .sql file and the file is executed as
>What query, exactly? Which PG version is this?
> regards, tom lane
Its a query involving 15 relations, processing not more than 500 records. The
query is written in a .sql file and the file is executed as
\i initq.sql
Infact, know no .sql file is getting executed. All my .sqls
Hi,
I am getting the following error while processing a query.
"server process was terminated by exception xc005"
Please help me resolve this.
Regards
Swati
199774
width=8)
(5 rows)
This is the plan I was getting with my original query which took so
long.
Also the second Update was very slow. Deletes, and inserts were quite
fast.
> It would also help to know what version of PostgreSQL this is and on
> what hardware and setup you're running into
n key to
> > > another table.
> > That seems unlikely to be the cause.
It's just what I saw. First I tried with all the FKs but had to break
the queries because they took too long.
Then I dropped the FK and the query run in a couple of minutes.
Thanks,
MS
--
Sent via pgsql-gen
Hi,
I have a query with 20 relations, the GEQO is used to solve this query.
When the value of
pool->data[i].worth
was displayed, from random_init_pool() [geqo_pool.c], exactly the same value
was obtained for all individuals.
Also when the value of pool->data[i].worth was printed from ge
#x27;t there a way to make
some bulk operations without having to drop indexes/FKs?
Something that would work like:
begin transaction + forget about RI
make some lenghty operation (update/delete...)
if RI is OK then commit; else rollback
Thanks,
MS
--
Sent via pgsql-general mailing list (pgsql-
> I never cease to be amazed at how many times people have these monster
> CPUs, like dual quad core 3Ghz processors, with 16GB or whatever of ram,
> and then try and run a database off a single 7200 rpm desktop SATA
> drive. at work our production databases often run on dozens of 1
> or 15
Btw. It looks like this issue:
http://archives.postgresql.org/pgsql-performance/2007-09/msg00374.php
In my case the CPU usage is low too (3%) but IO wait is high (95%).
I'm using Postgresql 8.3.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Thanks Andres, > 1. Since the value of geqo_threshold is 12, does the geqo get
automatically
> activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact that even a predefined order like:
a JOIN b
Hi,
I have a few queries on the use of the geqo.
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
2. Can the geqo threshold be set to a smaller value like 4 or 5?
3. How do we come to know whether the geqo has been used to
Hi,
I built and installed Postgresql 8.4.0 from source using Visual Studio 2005 on
Windows XP.
All build and installation steps executed successfully as mentioned in the
Postgresql Documentation, but server could not be started.
Given below is the detail of the problem I am facing.
>From user P
Hi,
Thank you all for your kind responses.
Things however aren't falling in place.
Will take a short break, rework, and get back.
Probably, with a new problem!
Thanks again,
Regards
Swati
Hi,
I started everything again from scratch.
1. Created a new user("Swati"), with limited/ restricted rights.
Ensured that no password is set anywhere.
2. Ran initdb from the new user.
c:\postgresql\bin>initdb -D c:\postgresql\data2
It displayed the DEBUG: start transact
I think I can understand what you both have discussed.
But I am unable to unearth my mistake.
Regards
Swati
--- On Wed, 7/8/09, Andreas Wenk wrote:
From: Andreas Wenk
Subject: Re: [GENERAL] [Re: Password?]
To: "Steve Atkins"
Cc: "pgsql-general List"
Date: Wednesday, July 8, 2009, 11:20 PM
Yes,
Its the currently logged on user.
--- On Wed, 7/8/09, Andreas Wenk wrote:
From: Andreas Wenk
Subject: [Re: [GENERAL] Password?]
To: "PG-General Mailing List"
Date: Wednesday, July 8, 2009, 3:54 PM
Serge Fonville schrieb:
>> *argh* - more detailed to avoid confusion. The auth method 'p
>ah ok ..
>Actually it should work if you set listen_addresses to '*' in postgresql.conf.
>Did you >change anything else in postgresql.conf or pg_hba.conf?
>I am not too experienced with Windows so maybe someone with more knowledge is
>able >to find the trick (I installed 8.4 once with the one
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere. Which
password is it asking for?
Please help.
I have built from source on Windows XP.
Thanks is advance,
Regards
Swati
Hi,
You may obtain the required files from:
http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
for MS-VC++, by Hiroshi Saito
Copy uuid.h and uuid.lib from here to appropriate folders and it should work.
Swati Chande
22 matches
Mail list logo
