s on my part... could that error be the result of an attempt to map
shared memory 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
_
>- 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 A
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
me he 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 <[EM
ng limit like 175 as I can
consistently crash Postgresql on Windows 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
--- 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
> >
B of ram so I'm highly doubtful that IBM would have configured
it to boot 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
---
?
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 'ki
rned in under 0.1ms I
think you may be engaging 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
__
this convention directly in ECPG (assuming it doesn't
create maintenance/security issues) for anyone porting applications from Oracle
to Postgresql.
Regards,
Shelby Cain
Be a better friend, newsh
roblem and shuts
down. The end result is the log file being spammed
with "FATAL" entries regarding the process. I've
attached a small excerpt from my log files.
Any ideas as to what is going on?
Regards,
Shelby Cain
__
Do you Yah
No such file or directory"
I suspect that is the critical clue as to what might
be happening on this box.This is a default
installation with a few deviations from the supplied
default config. Any other ideas?
Regards,
Shelby Cain
__
Do Y
nus
>
Well then I guess I'll be leaving 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_2
lso
be covered under the GPL. No commercial license 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
st Windows fans don't see that their OS as
unstable because it isn't - unless of course you are
referring to the non-NT variations.
Regards,
Shelby Cain
__
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospectiv
> it just seems to see the '%' as a normal character.
>
> How can this be done in PostgreSQL?
>
I suspect that, unlike Access, PostgreSQL will
intrepret C-style escape sequences (ie: \r, \n, \t) so
you'll need to properly escape the backslash in aPath
like so
--- [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.
>
planner picked
an index scan for the city = 'X' condition but for
what I feel are the wrong reasons because it under
estimated the row count. Re-analyzing the table
multiple times always shows about an 8k estimate.
Is my data set that promblema
code columns
> of the table (offlist of course)? COPY TO with a
> column list can
> extract that for you.
>
I had already removed proprietary data to try and
whittle down the number of columns I needed to
demonstrate the weirdness so I can host a dump of the
table. Howeve
tions for all
users/databases and use md5 challenge/response for
password authentication over the wire.
Regards,
Shelby Cain
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
.Net and C#) + the free
.NET 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
hat you can place on
forms.
As an aside, I'd highly 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
_
bulk mail folder but this
account used to only receive maybe 5 spam emails a month.
Regards,
Shelby Cain
__
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
--
-
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
>
Were you sleeping every time through the loop? How about something
like:
if (j%500 == 1) usleep(10)
Regards,
Shelby Cain
__
Dis
believe the odds of two arbitrary inputs yielding the same MD5 hash
would be 1 in 2^128. Even though the odds 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
54.02 MB/sec
Whirlpool: 17.51 MB/sec
Elapsed time: 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
___
rver using psql (somewhat better but still slow for 37000
> rows):
>devel=# select * from pp_users;
>Time: 912.779 ms
This is telling me 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)
are asking because of the existence of pgsql-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! M
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 Window
ed
HINT: Increase the configuration parameter "max_stack_depth".
DROP TABLE
Regards,
Shelby Cain
- Original Message
From: Markus Schiltknecht <[EMAIL PROTECTED]>
To: pgsql general
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
Sent: Thursday, November 2, 2006 9:55:08 AM
Subject: Re: [GENERAL] lots of values for IN() clause
Hi,
thanks
hoose the desired behavior?
Regards,
Shelby Cain
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ing a
proper module 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
To: Shelby Cain
I hadn't considered that. Thanks.
Regards,
Shelby Cain
- Original Message
From: Martijn van Oosterhout
To: Shelby Cain <[EMAIL PROTECTED]>
Cc: pgsql-general
Sent: Wednesday, November 15, 2006 1:15:02 AM
Subject: Re: [GENERAL] PG_MODULE_MAGIC check in 8.2
That said, do
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: Je
ly limited 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: O
editing 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, Febru
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
S
g/docs/8.1/static/sql-createfunction.html
Check out the difference between "security invoker" and "security
definer". If the creating user has the necessary access to the
underlying objects you'll get the behavior you desire.
Shelby Cain
_
al with the difference between the two server sql dialects.
All in all, 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!?
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 - which
--- 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 ps
ged to narrow the case when it happens 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 sm
can't use APT.)
>
Try http://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
-
--- 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.
>- Original Message
>From: Tom Lane <[EMAIL PROTECTED]>
>To: Csaba Nagy <[EMAIL PROTECTED]>
>Cc: Postgres general mailing list
>Sent: Friday, May 19, 2006 9:31:24 AM
>Subject: Re: [GENERAL] allow LIMIT in UPDATE and DELETE
>
>You can't possibly think that that holds true in general.
>
>I
those changes put into production. Having 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
- Original Message
>From: Csaba Nagy <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: [EMAIL PROTECTED]; Postgres general mailing list
>>; [EMAIL PROTECTED]
>Sent: Friday, May 19, 2006 11:46:42 AM
>Subject: Re: [GENERAL] allow LIMIT in UPD
- Original Message
>From: Jim C. Nasby <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Csaba Nagy <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; >Postgres general
>mailing list ; >[EMAIL PROTECTED]
>Sent: Monday, May 22, 2006 5:04:51 PM
- Original Message
>From: Jim C. Nasby <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Csaba Nagy <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; Postgres >general
>mailing list ; [EMAIL PROTECTED]
>Sent: Tuesday, May 23, 2006 5:19:58 PM
&g
or or perhaps a bug?
Regards,
Shelby Cain
=
c1scain=# select version();
ve
--- 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 decl
tentional cast on #3 throw the optimizer row count
estimate so far off but not for #4 even though both
(correctly) ignored the index on txn_date and opted
for a sequential scan instead? The txn_date column
has statsistics set to 500 and these results are after
a full vacuum and
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&#x
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
that means 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
'm more curious 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
"
INFO: "inventory_txns": 39549 pages, 15 rows
sampled, 944729 estimated total rows
VACUUM
It still decided to sample 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
ng my 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.
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
mater
starting" which is immediately followed up 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
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.
>
>
x27;m seeing such a huge
performance difference in vacuum between 7.4.x and
8.0?
Regards,
Shelby Cain
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
---(
its
>From looking at vacuum.c I gathered vacuum_cost_delay
must be >0 to enable the feature - correct?
Regards,
Shelby Cain
__
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Shelby Cain <[EMAIL PROTECTED]> writes:
> > From looking at vacuum.c I gathered
> vacuum_cost_delay
> > must be >0 to enable the feature - correct?
>
> Yeah, that's right --- delay=0 turns it off. Weird
the assumption that the 7.4 code 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()/_commi
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.
R
reciated.
>
You might want to look at the source 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 stora
68 matches
Mail list logo
