porting applications from Oracle
to Postgresql.
Regards,
Shelby Cain
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt
in premature optimization by adding indexes to this
table. If you expect that table to eventually contain many thousands of
entries then an index might be prudent.
Regards,
Shelby Cain
Be a better
?
Regards,
Shelby Cain
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 2: Don't 'kill -9
system right around the 200th
connection.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 3
--- Trevor Talbot [EMAIL PROTECTED] wrote:
On 10/20/07, Shelby Cain [EMAIL PROTECTED] wrote:
I'd personally vote for a lower warning limit like 175 as I can
consistently crash Postgresql on Windows system right around the
200th
connection.
What error gets logged for your crashes
with the /3GB switch.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
starts Postgresql.
Compared to that, I don't really understand follow your argument as to why
installing Postgresql as a service and stopping/starting it through the service
control panel such a big deal.
Regards,
Shelby Cain
- Original Message
From: Zenaan Harkness [EMAIL PROTECTED
- Original Message
From: Magnus Hagander [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: Alvaro Herrera [EMAIL PROTECTED]; Terry Yapt [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Friday, August 24, 2007 1:08:44 AM
Subject: Re: [GENERAL] FATAL: could not reattach
I apologize for resending this but my editor in combination with Yahoo's web
mail interface horribly mangled it...
- Original Message
From: Magnus Hagander [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: Alvaro Herrera [EMAIL PROTECTED]; Terry Yapt [EMAIL PROTECTED];
pgsql
into a process at a fixed location that just happens to already
be occupied by a dll that Windows had decided to relocate?
Regards,
Shelby Cain
Pinpoint customers who are looking for what you sell.
http
Since he has so many connections, perhaps the crash is related to bugs #2609
and #1641? 8.2.x seems to have the problem as well.
Regards,
Shelby Cain
- Original Message
From: Scott Marlowe [EMAIL PROTECTED]
To: Goran Rakic [EMAIL PROTECTED]
Cc: pgsql general pgsql-general
of configuration files.
===
That doesn't sound like a very useful methodology for benchmarking.
Regards,
Shelby Cain
- Original Message
From: Marc Evans [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, February 15, 2007 12:21:03 PM
certain features of the TCP/IP stack (e.g.: low limits
for the TCP connection backlog). In theory, if you had a flood of incoming
connections only some of them would be serviced correctly before the backlog
limit was reached.
Regards,
Shelby Cain
- Original Message
From: Oisin Glynn
I hadn't considered that. Thanks.
Regards,
Shelby Cain
- Original Message
From: Martijn van Oosterhout kleptog@svana.org
To: Shelby Cain [EMAIL PROTECTED]
Cc: pgsql-general pgsql-general@postgresql.org
Sent: Wednesday, November 15, 2006 1:15:02 AM
Subject: Re: [GENERAL
Do you have antivirus software installed on the server? I seem to recall A/V
software being a common source of permission denied errors when running
Postgresql on Windows.
Regards,
Shelby Cain
- Original Message
From: Ardian Xharra [EMAIL PROTECTED]
To: Jeff Davis [EMAIL PROTECTED
the desired behavior?
Regards,
Shelby Cain
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
that wraps the calls later. Since I am familiar with building
Postgresql from source that is something I'd much rather do after removing the
check for a short-term solution.
Regards,
Shelby Cain
- Original Message
From: Martijn van Oosterhout kleptog@svana.org
To: Shelby Cain [EMAIL
the configuration parameter max_stack_depth.
DROP TABLE
Regards,
Shelby Cain
- Original Message
From: Markus Schiltknecht [EMAIL PROTECTED]
To: pgsql general pgsql-general@postgresql.org
Sent: Thursday, November 2, 2006 9:21:52 AM
Subject: [GENERAL] lots of values for IN() clause
Hi
No segfault in 8.1.5 on win32 either...
- Original Message
From: Markus Schiltknecht [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Thursday, November 2, 2006 9:55:08 AM
Subject: Re: [GENERAL] lots of values for IN() clause
Hi
- Original Message
From: Jim C. Nasby [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: Csaba Nagy [EMAIL PROTECTED]; [EMAIL PROTECTED]; Postgres general
mailing list pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 5:19:58 PM
Subject: Re: [GENERAL] allow
- Original Message
From: Jim C. Nasby [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: Csaba Nagy [EMAIL PROTECTED]; [EMAIL PROTECTED]; Postgres general
mailing list pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Monday, May 22, 2006 5:04:51 PM
Subject: Re: [GENERAL] allow
. If there could be a
performance gain in Postgresql with delete from X where Y limit Z vs delete
from X where Y in (some subselect limit Z) I'd think Csaba suggestion has some
merit.
Regards,
Shelby Cain
---(end of broadcast)---
TIP 9: In versions
a internal developer use a script to
perform such maintenance as a batch process is considered free so you can
guess how many such processes have been created over the years.
Regards,
Shelby Cain
---(end of broadcast)---
TIP 5: don't forget
- Original Message
From: Csaba Nagy [EMAIL PROTECTED]
To: Shelby Cain [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Postgres general mailing list
pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Friday, May 19, 2006 11:46:42 AM
Subject: Re: [GENERAL] allow LIMIT in UPDATE and DELETE
--- Ludek Finstrle [EMAIL PROTECTED] wrote:
Hi all. I having an issue with the 8.01.01.02 ODBC driver that is
installed via the 8.1.x Windows installer.
...
Anyone have any ideas whats going on or how I can get back to the
8.0.x
behavior?
There is newer 08.01 psqlODBC version.
down a bit. I only receive
the The connection is dead error when an error occurs after I've
explicitly defined a transaction via ADO.Net's
OdbcConnection.BeginTransaction() function.
I'd be happy to send you a small C# test case in if you wish.
Regards,
Shelby Cain
://pdo.debian.org/ instead for the time being.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP
--- Redefined Horizons [EMAIL PROTECTED] wrote:
It looks like the packages.debian.org site is down. Is there another
place where I can download a .deb for the latest stable version of
PostgreSQL. (I don't have a direct link to the internet on my Linux
box, so I can't use APT.)
Sorry...
Hi all. I having an issue with the 8.01.01.02 ODBC driver that is
installed via the 8.1.x Windows installer.
Whenever there is an error on the connection (eg: trying to execute a
sql statement that has a syntax error as an example) the
System.Data.OdbcConnection object throws an exception -
, you'd be much better off designing your application such
that it explicitly supports multiple databases to begin with.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
. If the creating user has the necessary access to the
underlying objects you'll get the behavior you desire.
Shelby Cain
__
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
---(end
Additionally, you should also take the opportunity to defrag the
filesystem after the conversion as the change in cluster size (I'm
guessing from 64k to 4k) will leave your shiny new NTFS file system
highly fragmented.
--- Wes Williams [EMAIL PROTECTED] wrote:
Type the following at the Windows
-doc, I'd say
posting here in pgsql-general would be fine. I believe pgsql-doc is
focused on the official project documentation distributed with pgsql.
Regards,
Shelby Cain
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
your local interface returned 40 megs of data from
the backend to the client in under a second (perhaps disk I/O is the
bottleneck here). Once again, that doesn't sound like an unreasonable
figure to me.
What is your OS/hardware/etc?
Regards,
Shelby Cain
: 3.56 seconds
Average throughput: 121.06 MB/s
Granted, MD5 isn't the quickest hashing algorithm out there but it is
certainly fast enough for general use IMO.
Regards,
Shelby Cain
__
Discover Yahoo!
Find restaurants, movies, travel and more fun
of collision are small
you'll want to write your query such that use use the index on the hash
and then filter on the text field to guarantee you get the result you
are interested in.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
sleeping every time through the loop? How about something
like:
if (j%500 == 1) usleep(10)
Regards,
Shelby Cain
__
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
http://discover.yahoo.com/stayintouch.html
recommend learning how ADO.Net works at the
fundamental level so that you can (if necessary) code these things
manually instead of having to rely on the forms designer provided by
VS.Net.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo
SDK from Microsoft?
I realize that Tony Caduto may possibly encourage me to buy Delphi.
I remember the Borland of old that offered extraordinarily powerful
tools at a reasonable price. Unfortunately, they are not the same
company they used to be.
Regards,
Shelby Cain
Discover
the number of columns I needed to
demonstrate the weirdness so I can host a dump of the
table. However, before I take that step I should
mention that this is the native Windows port so if
that changes anything let me know.
Regards,
Shelby Cain
__
Do
over the wire.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 2: you can get off all lists
it under
estimated the row count. Re-analyzing the table
multiple times always shows about an 8k estimate.
Is my data set that promblematic? Has anyone seen
similar behavior? Any suggestions on how to improve
these stats?
Regards,
Shelby Cain
__
Do
--- [EMAIL PROTECTED] wrote:
Hi,
I'm trying to execute COPY command from some pgsql
function.
The filename is given as an argument of the
function.
But I get the filename like 'F:\tmp\file.txt' and I
need to change this to
'F:/tmp/file.txt' before applying the COPY command.
I
the backslash in aPath
like so:
folder1\\folder2\\folder3
Regards,
Shelby Cain
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
---(end of broadcast
it isn't - unless of course you are
referring to the non-NT variations.
Regards,
Shelby Cain
__
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective
is
required unless the terms of the GPL (ie: if you
distribute a binary to someone you must also be
willing to distribute your source code if asked) a
problem.
Regards,
Shelby Cain
__
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective
that off for the
time being. Thanks for the response. :)
Regards,
Shelby Cain
__
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
---(end of broadcast
for the current
8.0 beta installer at http://pgfoundry.org/ for
inspiration.
Regards,
Shelby Cain
__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
Is there any way to retrieve the error code and error
message text when an exception has been caught via
exception when others in pl/pgsql? I'm looking
essentially for the equivalent of Oracle's pl/sql
sqlerrm and sqlcode variables.
Regards,
Shelby Cain
was simply not
syncing.
Sounds reasonable. However, I don't see the same
performance hit while doing bulk database operations
(ie: inserts, deletes, updates). Is that expected
behavior? Do vacuum operations fsync()/_commit() more
often?
Regards,
Shelby Cain
and
8.0?
Regards,
Shelby Cain
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
?
Regards,
Shelby Cain
__
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
with a
dialog box:
The application failed to initialize properly
(0xc142). Click OK to terminate the application.
This is on a Windows 2000 SP4 system with PostgreSQL
installed via the beta installer.
Regards,
Shelby Cain
__
Do you Yahoo!?
New
Thanks for the info.
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Right, you can not use them both because the
statistics per statement
and per-stage can't be done with the one set of
system counters we have.
The server logs should show the cause with a
description of this.
This
Glad I could help. As Dustin pointed out, pg_dump
will return a non-zero value to indicate an error.
Regards,
Shelby Cain
--- Anony Mous [EMAIL PROTECTED] wrote:
Thanks again. I've got it working using the API
calls described.
pg_dump does return an exit code of 0 upon success.
Does
it isn't the vacuum but the analyze
that is eating all my precious ram. :)
Any tips on minimizing the memory footprint during
analyze (ie: backing off the 300 setting that I'm
currently using) or is this just something I'll have
to live with?
Regards,
Shelby Cain
--- Tom Lane [EMAIL PROTECTED] wrote
about whether I was
overlookign a setting that could reduce the memory
footprint during a vacuum analyze cycle than about
getting it reduced. If it becomes a major pain I'll
simply run the thing on off hours while I'm not at
work. :)
Regards,
Shelby Cain
--- Uwe C. Schroeder [EMAIL PROTECTED
15 rows. Am I missing
something obvious here? Shouldn't fewer rows be
sampled when I set the collection target to 1?
Regards,
Shelby Cain
--- Tom Lane [EMAIL PROTECTED] wrote:
... the issue is obviously ANALYZE and not VACUUM at
all. What
statistics targets are you using? It's hard
curiosity on the matter.
I've learned something that I didn't readily pick up
from reading the documentation.
Regards,
Shelby Cain
--- Tom Lane [EMAIL PROTECTED] wrote:
Shelby Cain [EMAIL PROTECTED] writes:
It still decided to sample 15 rows. Am I
missing
something obvious here
You have to update the credentials stored in the
service configuration.
Start-Run-services.msc-[service name]-Logon
Regards,
Shelby Cain
--- Bill Harris [EMAIL PROTECTED]
wrote:
I asked on cygwin but no answer yet; maybe someone
here knows.
I've been running PostgreSQL 7.4.1 successfully
You could spawn pg_dump via CreateProcess and call
WaitForSingleObject() on the handle that CreateProcess
returns in a worker thread. When the Wait() function
returns, you can then call GetExitCodeProcess() on the
same handle to get the process exit code.
Just a thought.
Regards,
Shelby Cain
instead? The txn_date column
has statsistics set to 500 and these results are after
a full vacuum and analyze.
Regards,
Shelby Cain
__
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
---(end
--- Tom Lane [EMAIL PROTECTED] wrote:
Hoo, I'm surprised no one noticed this during 7.4
development/testing.
The problem applies for any datatype that requires
double alignment,
which includes int8, float8, and timestamp as well
as most of the
geometric types. pg_statistic is declared as
or perhaps a bug?
Regards,
Shelby Cain
=
c1scain=# select version();
version
64 matches
Mail list logo