For the time being, I dropped a few tables in a scratch DB that I was
experimenting with. I just reran the app that gave me the messages before and
this time no messages. Tonight, I'll cycle the DB with the new fsm value.
Thanks for all the help!
(BTW, just have to say that the help I get her
Bill Moran writes:
> In response to "Gauthier, Dave" :
>> There is no way I have 1000 tables/indexes. But maybe it's counting
>> table/index file extensions in the mix? What's the metadata query to see
>> these 1000 relations?
> Are you counting tables, indexes, sequences, pg_toast tables, sy
On Fri, 27 Feb 2009, Gauthier, Dave wrote:
Is there a way I can spin that in without rebooting the DB (and kicking
my user off)?
Nope:
# select name,context from pg_settings where name='max_fsm_pages';
name | context
---+
max_fsm_pages | postmaster
That's
In response to "Gauthier, Dave" :
> Ya, most of it's system stuff. OK, I see where the 1000 comes from. I
> bumped it up to 1200 in postgresql.conf. Is there a way I can spin that in
> without rebooting the DB (and kicking my user off)?
No. Unless something has changed that I'm not aware of
Ya, most of it's system stuff. OK, I see where the 1000 comes from. I bumped
it up to 1200 in postgresql.conf. Is there a way I can spin that in without
rebooting the DB (and kicking my user off)?
-dave
-Original Message-
From: Bill Moran [mailto:wmo...@potentialtech.com]
Sent: Frid
In response to "Gauthier, Dave" :
> There is no way I have 1000 tables/indexes. But maybe it's counting
> table/index file extensions in the mix? What's the metadata query to see
> these 1000 relations?
Are you counting tables, indexes, sequences, pg_toast tables, system tables?
SELECT relna
There is no way I have 1000 tables/indexes. But maybe it's counting
table/index file extensions in the mix? What's the metadata query to see these
1000 relations?
-dave
-Original Message-
From: Bill Moran [mailto:wmo...@potentialtech.com]
Sent: Friday, February 27, 2009 3:03 PM
To:
In response to "Gauthier, Dave" :
> I just did a Vacuum Analyze on a DB. It worked OK, but I got...
>
>
> NOTICE: max_fsm_relations(1000) equals the number of relations checked
> HINT: You have at least 1000 relations. Consider increasing the
> configuration parameter "max_fsm_relations"
Th
On Fri, 2009-02-27 at 12:37 -0700, Gauthier, Dave wrote:
> I just did a Vacuum Analyze on a DB. It worked OK, but I got...
>
>
>
>
>
> NOTICE: max_fsm_relations(1000) equals the number of relations checked
>
> HINT: You have at least 1000 relations. Consider increasing the
> configuratio
I just did a Vacuum Analyze on a DB. It worked OK, but I got...
NOTICE: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the configuration
parameter "max_fsm_relations"
I browsed around and learned that this has to do
Richard Huxton escribió:
Linos wrote:
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
"id_seccion", "id_categoria" FROM "modelo_subfamilia"
PSQL with \timing:
-develo
On Fri, 27 Feb 2009 09:34:08 +
Richard Huxton wrote:
> > CREATE TRIGGER prevent_empty_updates BEFORE UPDATE ON test FOR
> > EACH ROW EXECUTE PROCEDURE prevent_empty_updates();
> >
> > Actually after writing this, this TOO does not seem to work after
> > an ADD COLUMN. :/ Any suggestions?
Linos wrote:
> Richard Huxton escribió:
>> Linos wrote:
>>> 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
>>> SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
>>> "id_seccion", "id_categoria" FROM "modelo_subfamilia"
>>
>>> PSQL with \timing:
>>> -developm
On Fri, Feb 27, 2009 at 12:00 PM, Enrico Sirola wrote:
> Hello,
>
> I'm having some troubles with the correct use of the execute plpgsql
> statement. Where I work, we have a postgresql db hosting a set of schemas
> all with the same tables and, from time to time, we upgrade the schemas to a
> new
Maxim Boguk writes:
> Tom Lane wrote:
>> Could you send me a dump of this test_table off-list? It seems like
>> there must be something strange about the stats of last_change_time,
>> but I don't feel like guessing about what it is ...
> Here attached is small part of table (1160 rows) wich show
On Fri, 2009-02-27 at 19:06 +0100, Tim Tassonis wrote:
> Joshua D. Drake wrote:
> > On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
> >> Hi all
> >>
> >> I remember, a while ago somebody mentioning an odbc driver for postgres
> >> that is not dependant on a working postgres client installat
Joshua D. Drake wrote:
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation.
Unfortunately I lost the link to it, can anybody remember?
ODBCng?
Is there a way in psql to hide the row counts but keep the column headers?
The man page talks about \t and --tuples-only, but both of those also
suppress column headers.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
Hi, check this out:
http://archives.postgresql.org/pgsql-general/2008-05/msg00938.php
I would say that execute is the only way to achieve some things
related to schemas and temp tables.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
Thank you very much for your advice, I guess I'm wasting my time in
this 'problem'. I'm going to check that class, it seems pretty useful.
And by the way...yes, this is a born-dead app (at least on the client
side) and it's likely to be ported to .NET in the future, but like I
said before, it's not
Hello,
I have a pgsql database hosting xml data in xml columns. The data,
have declarations at the beginning, so it is saved with
XMLPARSE (DOCUMENT )
when I try to restore a database from dump, pg_restore complains
because the data it tries to restore is not an xml content
(correctly),
Hello,
I'm having some troubles with the correct use of the execute plpgsql
statement. Where I work, we have a postgresql db hosting a set of
schemas all with the same tables and, from time to time, we upgrade
the schemas to a new version coding a stored procedure like the
following (pseu
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
> Hi all
>
> I remember, a while ago somebody mentioning an odbc driver for postgres
> that is not dependant on a working postgres client installation.
> Unfortunately I lost the link to it, can anybody remember?
>
ODBCng?
http://projects
1)Strip all Postgres and or user-specific custom datatypes
for ex if you see an in or out var declared as fubar chances are this wont map
correctly in Oracle
2)Get to know packages..they work well to aggregate and organise
2a)Functions and Procedures which are used for a specific purpose for ex
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
"id_seccion", "id_categoria" FROM "modelo_subfamilia"
PSQL with \timing:
-development: Time: 72,441 ms
-server: Time:
Linos wrote:
> 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
> SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
> "id_seccion", "id_categoria" FROM "modelo_subfamilia"
> PSQL with \timing:
> -development: Time: 72,441 ms
> -server: Time: 78,762 ms
> but
Hello i have the same table with the same data in my development machine and in
a small server in production. The table is this:
Tabla «modelo_subfamilia»
Columna| Tipo | Modificadores
---+---+---
nombre| character var
On Fri, Feb 27, 2009 at 11:57 AM, Gregory Stark wrote:
> Uh, we get a lot of really mangled SQL and explain plans -- I don't see
> anything wrong with these. If the question was unclear it sounds like it's
> just because it's a fairly subtle problem and was hard to describe. Needing
> two cracks
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation.
Unfortunately I lost the link to it, can anybody remember?
(
I tested it then and it worked fine for simple task, but then switched
back to the stan
Alban Hertroys writes:
> On Feb 26, 2009, at 11:02 AM, Grzegorz Jaśkiewicz wrote:
>
>> looks like you completely misunderstood my question.
>
> I'm not surprised. What do you expect with random capitalisation, random
> table
> alias names and random indentation combined with queries getting wr
A. Kretschmer escribió:
In response to Linos :
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
Other solution with p
In response to Linos :
> Hello,
> i have a query that returns a result set like this:
>
> item | size | stock
> 123 | XL | 10
> 123 | XXL | 5
> 123 | XS | 3
>
> and i would like get the results like this:
>
> item | XL | XXL | XS
> 123 | 10 | 5 | 3
Other solution with plain S
Thomas Kellerer escribió:
Linos, 27.02.2009 11:41:
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking h
Linos, 27.02.2009 11:41:
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking how to do it with a plpgsql
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking how to do it with a plpgsql function but the numbe
On Fri, Feb 27, 2009 at 3:16 AM, Grzegorz Jaśkiewicz wrote:
> 2009/2/27 Scott Marlowe :
>> Nope.
>
> as far as I can understand it, if I do the same thing in two steps,
> and in one step. And the latter is broken, because of some internal
> process/optimization/whatever - that's a bug to me.
You'
2009/2/27 Scott Marlowe :
> Nope.
as far as I can understand it, if I do the same thing in two steps,
and in one step. And the latter is broken, because of some internal
process/optimization/whatever - that's a bug to me.
Unless I am expecting it to work, and it was just pure luck that it
worked
On Fri, Feb 27, 2009 at 3:10 AM, Grzegorz Jaśkiewicz wrote:
> 2009/2/27 Scott Marlowe :
>> On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz
>> wrote:
>>
>>> First of all, I wonder why the same query divided up in half - and
>>> using temporary table works as expected, and with everything tog
2009/2/27 Scott Marlowe :
> On Thu, Feb 26, 2009 at 3:02 AM, Grzegorz Jaśkiewicz
> wrote:
>
>> First of all, I wonder why the same query divided up in half - and
>> using temporary table works as expected, and with everything together
>
> I'm betting it's your use of generate_series(). You can g
Josh Trutwin wrote:
> I found the following on a blog post
> (http://www.depesz.com/index.php/2007/09/08/avoiding-empty-updates/)
> which had a rule to prevent empty updates:
>
> CREATE RULE no_unchanging_updates AS
> ON UPDATE
> TO test_table
> WHERE ROW(OLD.*) IS NOT DISTINCT FROM ROW(NEW.*)
> D
Hi All,
I want to migrate from PostgreSQL to Oracle and need any tool preferably
open source. And I am specially concerned with stored procedures /
functions.
Regards,
Abdul Rehman.
You were just converting from Oracle to Postgres two days ago, so it
shouldn't take much to convert back.
41 matches
Mail list logo
