On Wed, Mar 07, 2007 at 07:46:16AM +0100, Martijn van Oosterhout wrote:
> On Tue, Mar 06, 2007 at 08:38:22PM +0200, andyk wrote:
> >This error is returned by libpq, as a reaction on WSANOBUFS error
> > from Windows Socket System. This means, applications tries to send much
> > data, and system
Tom Lane wrote:
Richard Huxton writes:
Alexander Elgert wrote:
I found the postgres version VERY slow, so a decided to fetch
Define VERY - it took what, milliseconds to do this? Seconds? Hours?
I think he's complaining that the standards-conformant view in Postgres
is slower than the spec
On Tuesday March 6 2007 11:52 pm, Peter Eisentraut wrote:
> Ed L. wrote:
> > Right. I'm asking if the fix for this problem is in the new
> > 8.1.8 software, or in the new DB structure resulting from
> > the initdb, or perhaps both.
>
> There is no new DB structure in 8.1.8, which is why you can
>
On Wed, Mar 07, 2007 at 02:29:08AM -0700, Ed L. wrote:
> Perhaps my question was not clear enough. Let me rephrase: Does
> the fix for this problem comes from a *fresh* DB structure
> resulting from the initdb, or from a software fix in 8.1.8, or
> both? The answer makes a big difference with
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
I programmed a little script which iterates over all databases in a
DBMS, iterating over all tables and then over all columns.
This skript works for mysql and postgres.
1. Solution overview
foreach database {
for
Hi,
hubert depesz lubaczewski wrote:
i contacted the company some time ago, and the information i got was
that their product is based on query-replication.
Yes, AFAIK, their solution is two phase commit based, like Sequoia.
Regards
Markus
---(end of broadcast)---
Hi,
On Wed, 2007-03-07 at 12:14 +0100, Markus Schiltknecht wrote:
> hubert depesz lubaczewski wrote:
> > i contacted the company some time ago, and the information i got was
> > that their product is based on query-replication.
>
> Yes, AFAIK, their solution is two phase commit based, like Sequoi
On Wed, Mar 07, 2007 at 12:12:52PM +0100, Alexander Elgert wrote:
> >Nope - \d is psql only. That's because what it does changes with the
> >system catalogues. If you want a stable representation, use the
> >information_schema. If you want all the PostgreSQL-specific details
> >you'll have to co
Alexander Elgert wrote:
This results in a structure where I can itereate over all keys in the
2-dim array.
You can see I iterate first over the databases and then over table AND
columns!
--- mysql: ~1s (Database X)
--- postgres: ~1s (Database Y)
;)
In contrast: ==
Hi,
Devrim GÜNDÜZ wrote:
Yes, AFAIK, their solution is two phase commit based, like Sequoia.
I thought it was PGCluster. At least this is what I understood from the
drawings.
Uhm, you're right, it looks very similar to PgCluster, not Sequoia. So
it's not two phase commit based, right?
Reg
Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
> Markus Schulz <[EMAIL PROTECTED]> schrieb:
> > > You can use pg_restore with -l to generate a listfile for all
> > > objects in the database. Then you can reorder this ($EDITOR) and
> > > then use -L to use this ordered listfile to e
Hello,
how can i choose a default data type for casts?
PG 7.4 has some problems to use an existing index, if the datatype not
match.
For example i have a int8 primary id column and search for this column,
i can't use the index for queries like:
SELECT ... WHERE id = 12345
if i'm use:
SELECT ...
Martijn van Oosterhout writes:
> ... Your real problem is that
> you're using the information_schema which has to do all sorts of extra
> work for standards compliance. If you don't need that you're going to
> be much better off just using the system catalogs.
To put that in some perspective:
re
Markus Schulz <[EMAIL PROTECTED]> writes:
> Is there a solution for PG 7.4 to choose the default datatype for this
> way of casting?
Yeah, it's called "update to 8.x" ...
regards, tom lane
---(end of broadcast)---
TIP 4: Ha
Hi,
My database stopped responding last night (Postgres 8.1.4).
at 2 am, a vacuum began running:
/usr/local/pgsql/bin/vacuumdb -afz
When I came in to work this morning, I could query some tables
but not others. There were many(100) processes like:
postgres 11791 6901 0 02:07 ?00:00:00
Tom Lane schrieb:
Martijn van Oosterhout writes:
... Your real problem is that
you're using the information_schema which has to do all sorts of extra
work for standards compliance. If you don't need that you're going to
be much better off just using the system catalogs.
To put that in
On Wed, 2007-03-07 at 10:08 -0600, John Gateley wrote:
> I'm guessing it's something related to table locks.
...
> Any pointers on what I should be looking for to prevent this from
> happening again? What information I should be tracking to figure
> out what is exactly happening?
Your inserts alm
Env: Windows XP sp2
Version: 8.2.1
I'm attempting to write a function which produces a script. The script
will contain steps necessary to drop/recreate all the functions. I've
got a helper function called 'dropprocsbyname' which takes a schema and
a proc name, finds all matching pg_proc rows an
"Chris Fischer" <[EMAIL PROTECTED]> writes:
> I'm attempting to write a function which produces a script. The script
> will contain steps necessary to drop/recreate all the functions.
If you're trying to modify functions that are in live use, don't drop
them. Just apply CREATE OR REPLACE FUNCTIO
On Wednesday February 7 2007 9:01 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > How do I fix this 7.4.6 issue short of initdb?
> > invalid page header in block 110 of relation "pg_statistic"
> > I looked at the block via pg_filedump (included below), and
> > it does not appear t
"Ed L." <[EMAIL PROTECTED]> writes:
> The truncate showed no errors. The vacuum analyze showed the
> same error in block 110 of the pg_statistic table.
Really!? Hm, I wonder if you have a reproducible problem. Would it be
possible for you to send me the physical pg_statistic file (off-list)?
I
On 06/03/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Anton Melser" <[EMAIL PROTECTED]> writes:
> Thanks for your reply. I am managing a db that has some export scripts
> that don't do a drop/create, but rather a delete from at the start of
> the proc (6 or 7 tables used for this, and only this). Now
OK, I modified things to use interpolation. Here's the updated query:
explain UPDATE Transactions
SET previous_value = previous_value(id)
WHERE new_value IS NOT NULL
AND new_value <> ''
AND node_id IN (351, 169, 664, 240);
And he
Any recommendations for vendors that can build custom servers?
Specifically opteron based with scsi raid.
Chris
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL P
I periodically take snapshots of my current development database to
facilitate recovery from screw-ups. I do so roughly like this:
createdb -EUTF-8 db-snapshot
pg_dump -Fc db | pg_restore -d db-snapshot
For which I get the fairly innocuous error:
pg_restore: WARNING: datab
[EMAIL PROTECTED] wrote:
Hi,
I have a GiST index on st_geometry type (a user defined type). It looks
like index is not getting hit when I use some geometric operator. Here
is the example of st_contains operator.
How can I force or direct the planner to use the GiST index? Am I
missing some
[EMAIL PROTECTED] wrote:
Have you considered using PostGIS (www.postgis.org) to provide OGC
compliant
spatial data management for Postgresql, including projection support,
indexing &
a good selection of spatial query functions?
Cheers,
Brent Wood
Hi,
I have a GiST index on st_geometry ty
On Wednesday March 7 2007 3:13 am, Martijn van Oosterhout wrote:
> On Wed, Mar 07, 2007 at 02:29:08AM -0700, Ed L. wrote:
> > Perhaps my question was not clear enough. Let me rephrase:
> > Does the fix for this problem comes from a *fresh* DB
> > structure resulting from the initdb, or from a sof
On Fri, 2007-03-02 at 11:09 -0800, David Fetter wrote:
> On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
> > Hello,
> >
> > Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
> > However I have spoken with a Alexey and Alvaro and Command Prompt has
> > decide
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Fri, 2007-03-02 at 11:09 -0800, David Fetter wrote:
>> On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
>> > Hello,
>> >
>> > Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
>> > However I have spoken with a Al
Any chance we can get WITH without RECURSIVE? That would be very
handy all by itself.
I thought Greg already did submitted that?
To my knowledge, it is not done. If it is, great!
Joshua D. Drake
---(end of broadcast)---
TIP 9: In ve
I've purchased a number of systems (a dozen or so) from avadirect.
http://www.avadirect.com
Their prices are excellent, hardware is solid quality, their service is
median. This is a discount shop, so don't expect lightening support. But you
can buy three fast AVA systems of top-notch quality f
Hi all,
I've got a query that looks through a table I use for my little
search engine. It's something of a reverse-index but not quite, where a
proper reverse index would have 'word | doc1, doc3, doc4, doc7' showing
all the docs the keyword is in, mine has an entry for eac
I've got a que
Hi all,
I am using a postgres database, and want to set a password for the account.
The default user name is 'postgres' and in order to set a password, I did an
alter user as below,
alter user postgres with password 'mypwd';
The command goes through fine, but the next time I log
Try
SELECT DISTINCT
rather than SELECT
That should return a result with unique records.
Madison Kelly wrote:
Hi all,
I've got a query that looks through a table I use for my little
search engine. It's something of a reverse-index but not quite, where
a proper reverse index would have 'wo
Hi all,
Got this kind of silly question. I'm trying to use pg_resetxlog.
Problem is the path to c:/Program Files//data doesn't get reached,
probably (space in between). How can I resolve this in order to run
this command ?
Regards,
Steven
---(end of broadcast)---
The command goes through fine, but the next time I log into postgres using
the command,
>>psql mydb postgres
>>it logs in, and doesnt ask me for a password at all. If I issue a command
like,
This is because you have trust in pg_hba.conf file, change it to md5 so it
asks for password every time y
Thank you very much Shoaib,
that worked fine !
Regards,
Steven
On 3/8/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Try using something like this --> "Program Files/PostgreSQL/data" (that is
with quotes for using spaces)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, Steven De V
38 matches
Mail list logo