On 21/07/11 23:03, mdxxd wrote:
> I'm still not sure what should I get. If i understand correctly Greg
> message, despite my workload, i7 won't have much benefit for me and I should
> get i5(i7=4 cores with HT=8, i5=4 cores)?
Probably, yeah. To be sure, you should *measure* your current workload.
On 22/07/11 13:20, Chris Curvey wrote:
in an earlier thread, the following query was submitted:
SELECT COUNT(*) FROM q
WHERE NOT EXISTS (SELECT 1
FROM t AS t
WHERE t.mid = q.mid);
and as part of his answer, David Johnson
Chris Curvey writes:
> in an earlier thread, the following query was submitted:
>> SELECT COUNT(*) FROM q
>> WHERE NOT EXISTS (SELECT 1
>> FROM t AS t
>> WHERE t.mid = q.mid);
> and as part of his answer, David Johnson responded
> 3. Also, you are using a correlated sub-query instead of a LEFT OU
in an earlier thread, the following query was submitted:
SELECT COUNT(*) FROM q
> WHERE NOT EXISTS (SELECT 1
> FROM t AS t
> WHERE t.mid = q.mid);
and as part of his answer, David Johnson responded
3. Also, you are using a correlated sub
Hi,
http://people.planetpostgresql.org/devrim/index.php?/archives/61-Update-from-PostgreSQL-yum-repository.html
Machine arrived, and configured. I am on holiday now, so things will
start working when I return next week or so.
Regards,
On Thu, 2011-07-21 at 11:17 -0500, Justin Pasher wrote:
> H
Hello,
I'm having trouble finding the RPM/SRPM for the latest version of
PostgreSQL 8.4.8 on RHEL4. I only need the SRPM if the standard RPM
doesn't use --enable-integer-datetimes (I recall reading at one point
that the default may be changing to --enable-integer-datetimes, but I
can't rememb
Use the Encode module to test/convert back and forth between UTF8 characters
and bytes for the SQL ASCII database. Assuming the input is already UTF-8:
use Encode qw(:all);
# connect to db, prepare insert statement, etc.
my $bytes = encode('utf8', $utf8_text);
$sth->execute($bytes, $i) or er
Thanks for all of the info guys. Sadly, i'm still a little confused :)
What i'm looking for is building a fast and reliable PC for my purposes
while getting the best bang for buck. I don't mind paying 500$, 1000$ or
2000$ if its WORTH it(i.e i'm looking for the point where paying extra won't
effect
I have an older database that was created with SQL-ASCII encoding. Over
time users have managed to enter all manner of interesting characters,
mostly via cut and paste from Windows documents. I'm attempting to clean up
and eventually the database to UTF8. I've managed to find most of the data
th
"Gavrina, Irina" writes:
> I've faced with the following problem: I'm trying to implement the auto
> start of postgres. My way is to use inittab:
> pg:2345:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster
> -D/usr/local/pgsql/data >> /usr/local/pgsql/server.log 2>&1" /dev/null
> Bu
Hi Tom
Thanks for your reply. I was restoring one schema (with data) at a time from
8.3 db to a pre-created empty 8.4 db. I received a lot of errors which game
down to me not restoring the public schema first. I also realized, I had not
created plpgsql language for the 8.4 db before I did the res
Jenish Vyaswrote:
> please let me know what is the maximum number of concurrent client
connection supported by Postgres
> 8.4.6
>
> max_connections =
>
> For my database,
>
> If I am running the test for more then 1000 concurrent active user it
is showing me error "running out
> of connection"
Hello,
I would like to recreate/replace a view, but there are 'dependant
objects' on it. Is there a way to 'unrestrict' the dependant check in
the current transaction, like it could be done with certain constraints?
Kind regards,
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@pos
On 21/07/2011 2:56 PM, Sofer, Yuval wrote:
Hi
Ok - but how do I install the patch in the link?
I pressed the latest "patch" link Tom Lane gave me (Patch by brar on 2011-07-07
12:37:47 AM: Added documentation, removed pgflex.pl and pgbison.pl. No changes to the
existing code. ), where I saw so
Original Message
Subject: Re: [GENERAL] compile postgres with visual studio 2010
From: Sofer, Yuval
To: Craig Ringer
Date: 21.07.2011 08:56
Hi
Ok - but how do I install the patch in the link?
I pressed the latest "patch" link Tom Lane gave me (Patch by brar on 2011-07-07
1
Hello
2011/7/21 Jenish Vyas :
> Hi All,
>
> please let me know what is the maximum number of concurrent client
> connection supported by Postgres 8.4.6
>
> max_connections =
>
> For my database,
>
> If I am running the test for more then 1000 concurrent active user it is
> showing me error “r
Hi All,
please let me know what is the maximum number of concurrent client
connection supported by Postgres 8.4.6
max_connections =
For my database,
If I am running the test for more then 1000 concurrent active user it is
showing me error “running out of connection”
I have set max_connect
On 07/19/2011 01:35 AM, Jon Smark wrote:
Hi,
I don't think this is really possible with postgres PLs generally.
Typically what you have to do is have a function that is called on an
interval that checks for alarms and runs them.
Thanks for the prompt reply. Just to clarify: you are saying th
Hi
Ok - but how do I install the patch in the link?
I pressed the latest "patch" link Tom Lane gave me (Patch by brar on 2011-07-07
12:37:47 AM: Added documentation, removed pgflex.pl and pgbison.pl. No changes
to the existing code. ), where I saw some correspondence and very long text
file
19 matches
Mail list logo
