No that is not I meant. The problem in Prepared statements is in that you
should determine SQL inside the function. I want to pass a query as a
parameter, as well as query parameters.
For example (I want to create a function like the following):
select *
from exec_query(
Plucker ( http://plkr.org/ ) is a tool for viewing documentation on
handhelds running the PalmOS, and I just noticed that they have the
PostgreSQL documentation available:
http://projects.plkr.org/postgresql-documentation/
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, M
Joseph S <[EMAIL PROTECTED]> writes:
> ... and when I notice that the tuplesperpage for the indexes is low (or
> that the indexes are bigger then the tables themselves) I know it is
> time for a VACUUM FULL and REINDEX on that table.
If you are taking the latter as a blind must-be-wrong conditio
Joseph S <[EMAIL PROTECTED]> writes:
> David Fetter wrote:
>> - Arrange to put TOAST tables belonging to temporary tables into
>> special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn
> Does this apply to indexes on temp tables as well? Or is this not even
> an issue with indexes?
Josh Tolley escribió:
> On 8/2/07, Gavin M. Roy <[EMAIL PROTECTED]> wrote:
> > Are you contemplating providing access to data that's currently not stored
> > in the pg_ catalog tables? I currently monitor the statio data,
> > transactions per second, and active/idle backends. Things that I think
On 8/2/07, Gavin M. Roy <[EMAIL PROTECTED]> wrote:
> Are you contemplating providing access to data that's currently not stored
> in the pg_ catalog tables? I currently monitor the statio data,
> transactions per second, and active/idle backends. Things that I think
> would be useful would be ave
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
Me too. I don't change my db schema that much, but I experience bloat
in the pg_tables that I don't expect. For instance pg_opclass needs a
VACUUM FULL/REINDEX once a week or I notice the indexes are larger than
the table itself. Could it
On 8/2/07, Sergey Moroz <[EMAIL PROTECTED]> wrote:
> The problem is that I can't find the way to exclude query parsing (prepare
> step) for custom queries. In other words I want to create a function that
> accepts a query text with "$1, $2, etc." and variables as params, executes
> the query and re
Me too. I don't change my db schema that much, but I experience bloat
in the pg_tables that I don't expect. For instance pg_opclass needs a
VACUUM FULL/REINDEX once a week or I notice the indexes are larger than
the table itself. Could it be my heavy use of temp tables?
Today I noticed that
Joseph S <[EMAIL PROTECTED]> writes:
> Me too. I don't change my db schema that much, but I experience bloat
> in the pg_tables that I don't expect. For instance pg_opclass needs a
> VACUUM FULL/REINDEX once a week or I notice the indexes are larger than
> the table itself. Could it be my hea
David Fetter wrote:
== PostgreSQL Weekly News - July 29 2007 ==
- Arrange to put TOAST tables belonging to temporary tables into
special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn
Does this apply to indexes on temp tables as well? Or is this not even
an issue with indexes
Joseph S <[EMAIL PROTECTED]> writes:
> My pg_shdepend table has a size of 16,384, but
> pg_shdepend_depender_index has a size of 19,169,280 and
> pg_shdepend_reference_index has a size of 49,152.
I'd be interested to see the usage pattern that made it get like that
...
r
Chris Browne wrote:
>
> The server does not need the overhead of having *any* of the "X
> desktop" things running; it doesn't even need an X server.
>
> You don't need X running on the server in order use those "enterprise
> management" tools; indeed, in a "lights out" environment, that server
>
Joseph S wrote:
> My pg_shdepend table has a size of 16,384, but pg_shdepend_depender_index
> has a size of 19,169,280 and pg_shdepend_reference_index has a size of
> 49,152. When I try to reindex the table I get:
>
> ERROR: shared table "pg_shdepend" can only be reindexed in stand-alone
> mod
My pg_shdepend table has a size of 16,384, but
pg_shdepend_depender_index has a size of 19,169,280 and
pg_shdepend_reference_index has a size of 49,152. When I try to reindex
the table I get:
ERROR: shared table "pg_shdepend" can only be reindexed in stand-alone mode
So is there any way I c
Richard Huxton wrote:
Try just adding the column, I'm guessing it was dropped while you were
taking out the old tsearch2 installation.
ALTER TABLE pagecontent ADD COLUMN textvector tsvector;
Thanks, that fixed the problem.
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*
On Wed, 2007-08-01 at 07:14 +0530, Merlin Moncure wrote:
> On 8/1/07, Decibel! <[EMAIL PROTECTED]> wrote:
> > David Fetter and I just came up with these, perhaps others will find
> > them useful:
> >
> > CREATE OR REPLACE FUNCTION array_to_set(anyarray, int) RETURNS SETOF
> > anyelement LANGUAGE S
Magnus Hagander wrote:
> Andrei Kovalevski wrote:
>>> Have you done any development yet?
>> Yes, you can download and try it. Now it's a single pgtray.exe
>> application. I'm going to make an msi installer and add "Autostart"
>> option to the menu.
>
> When you do the installer, please make sure
Jon Lapham wrote:
After upgrading from Postgres 8.1 to 8.2 (via pg_dumpall) I had problems
with mediawiki (v1.9.2) that utilized tsearch2. I thought I had fixed
the problem by removing tsearch2 in my v8.1 databases, pg_dumpall-ing
and reloading to v8.2, and re-installing tsearch2 from scratch.
"Gauthier, Dave" <[EMAIL PROTECTED]> writes:
> After a db restore failed for reasons having to do with lack of disk
> space, when I try to restart the DB, I get...
> 2007-08-02 14:17:14 PANIC: could not fsync control file: Disk quota
> exceeded
> If the DB is trashed, how can I just delete it and
On 8/2/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
> On 8/3/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>
> > they do, but experience has shown it is prudent to be able to
> > administrate the hardware directly from the box.
>
> I'm curious: which aspect of hardware administration
> on a Li
I usually monitor blks_read and blks_hit (of block level stats), when
the latter is high
I see shared memory is doing a good job, when the former then it also
shows something
Also, database-wide number of commits and rollbacks (btw, Slony has a habit of
calling ROLLBACK when it done nothing -- I w
On 8/3/07, Ben <[EMAIL PROTECTED]> wrote:
> > I'm curious: which aspect of hardware administration
> > on a Linux box would require X (to be running)? If I *really*
> It's not that it can't be done, it's that having a window environment can
> make things easier. (I find 24x80 pretty cramped, and
On Fri, 3 Aug 2007, Andrej Ricnik-Bay wrote:
I'm curious: which aspect of hardware administration
on a Linux box would require X (to be running)? If I *really*
It's not that it can't be done, it's that having a window environment can
make things easier. (I find 24x80 pretty cramped, and I l
After a db restore failed for reasons having to do with lack of disk
space, when I try to restart the DB, I get...
dfg_suse> postmaster -D /proj/cad_sserv/cellibcmp/daveg/Postgres/DB -i >
/proj/cad_sserv/cellibcmp/daveg/Postgres/postmaster.log &
[1] 29644
dfg_suse> 2007-08-02 14:17:14 LOG:
On 8/3/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> they do, but experience has shown it is prudent to be able to
> administrate the hardware directly from the box.
I'm curious: which aspect of hardware administration
on a Linux box would require X (to be running)? If I *really*
needed applet
After upgrading from Postgres 8.1 to 8.2 (via pg_dumpall) I had problems
with mediawiki (v1.9.2) that utilized tsearch2. I thought I had fixed
the problem by removing tsearch2 in my v8.1 databases, pg_dumpall-ing
and reloading to v8.2, and re-installing tsearch2 from scratch.
When updating a
Andrei Kovalevski wrote:
>> Have you done any development yet?
> Yes, you can download and try it. Now it's a single pgtray.exe
> application. I'm going to make an msi installer and add "Autostart"
> option to the menu.
When you do the installer, please make sure it's compatible with
stackbuilder
Tony Caduto wrote:
> Andrei Kovalevski wrote:
>>Hi all!
>>
>>Everyone who use PostgreSQL server on Windows knows - it would be
>> nice to have some tray management and monitoring tool for PostgreSQL
>> server which is running as NT Service (for example - MS SQL already
>> have such tool).
On 8/2/07, Vincenzo Romano <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> Is there a way to write an SQL function like this:
>
> create or replace function afunction( recid bigint )
> returns bigint as $body$
> update atable set afield=0 where recid=$1 returning anotherfield;
> $body$ language SQL;
>
> I
On Wed, 2007-08-01 at 21:42 -0500, Mason Hale wrote:
> The score in this case are definitely not a normal distribution. They
> follow a power law pattern, with a few with very high scores and a
> long tail.
>
> I ended up coercing it to use plan 2 by dropping the index on
> topic_feed(score).
>
Andrei Kovalevski wrote:
Hi all!
Everyone who use PostgreSQL server on Windows knows - it would be
nice to have some tray management and monitoring tool for PostgreSQL
server which is running as NT Service (for example - MS SQL already
have such tool). I have created a new project on p
I'd like to know what the age of the oldest running transaction is.
i.e. hunt look out for old idle in transaction transactions that are
holding up vacuuming.
Info on the shared buffers like % used, % that hasn't been updated or
seen in x minutes / hours / days.
% used on various tablespaces
con
"Elena Camossi" <[EMAIL PROTECTED]> writes:
> Hi list,
>
> what is the default implementation for GiST index? B-Tree or R-Tree?
> That is, if i execute the following SQL command:
>
> CREATE index ON table USING Gist (column)
>
> what is the type of the index that is actually built?
uhm, GIS
Tony Caduto wrote:
Andrei Kovalevski wrote:
Hi all!
Everyone who use PostgreSQL server on Windows knows - it would be
nice to have some tray management and monitoring tool for PostgreSQL
server which is running as NT Service (for example - MS SQL already
have such tool). I have create
Hi all.
Is there a way to write an SQL function like this:
create or replace function afunction( recid bigint )
returns bigint as $body$
update atable set afield=0 where recid=$1 returning anotherfield;
$body$ language SQL;
If i write the function this way, postgres will complain that
the update
In response to ProAce <[EMAIL PROTECTED]>:
> I use SAN, not NAS. :)
>
> Because some bugdet issue, I just have a basic SAN environment.
> For multipathing, I use geom_fox to complete.
> For snapshot, I want to use mksnap_ffs.
>
> But I don't have any experience of using mksnap_ffs to backup pg
[EMAIL PROTECTED] ("Merlin Moncure") writes:
> On 8/2/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> Pardon me for being the contrarian, but why does a server need a
>> GUI? Isn't that just extra RAM & CPU overhead that could be more
>> profitably put to use powering the application?
>
> A server w
I use SAN, not NAS. :)
Because some bugdet issue, I just have a basic SAN environment.
For multipathing, I use geom_fox to complete.
For snapshot, I want to use mksnap_ffs.
But I don't have any experience of using mksnap_ffs to backup pgsql.
Does anyone give me some advice?
2007/8/2, Bill Mor
On 2/8/07 13:35, in article
[EMAIL PROTECTED], "Michael Knudsen"
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have created a database and imported a lot of data. I would like to
> share this database with other people but they should not be able to
> change anything. That is, they should only be all
Hi list,
what is the default implementation for GiST index? B-Tree or R-Tree?
That is, if i execute the following SQL command:
CREATE index ON table USING Gist (column)
what is the type of the index that is actually built?
If I specify R-Tree instead, with:
CREATE index ON table USIN
The size of my db is more then 50GB , so I consider that the pg_dump
is not a good backup tool for me.
And, sometimes, I need query data which is some days ago ( between 1 ~
14 days ).
If I want to transfer my db to different PG version, I will use slony-I. :)
I worried that mksnap_ffs spend muc
Hi all!
Everyone who use PostgreSQL server on Windows knows - it would be
nice to have some tray management and monitoring tool for PostgreSQL
server which is running as NT Service (for example - MS SQL already have
such tool). I have created a new project on pgfoundry -
http://pgfound
Hkrenske wrote:
I have been successful in installing to Windows 2000 but when
installing the binary installation “postgresql-8.2.msi” as a service,
I receive the error
The program "postgres" is needed by initdb but was not found in the
same directory as "C:/Program Files/PostgreSQL/8.2/bin/
I have been successful in installing to Windows 2000 but when installing the
binary installation "postgresql-8.2.msi" as a service, I receive the error
The program "postgres" is needed by initdb but was not found in the
same directory as "C:/Program Files/PostgreSQL/8.2/bin/initdb".
Check yo
On 8/2/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>
> > A server with a GUI sitting on a login screen is wasting zero
> > resources. Some enterprise management tools are in java which require
> > a GUI to use so there is very little downside to in
Hi,
I have some experience with HA-JDBC and on the whole it is pretty good (very
easy to setup), with it's only sight weakness being it synchronisation
(renders the DB read only) but this is to be improved in the future. I
have tried to setup sequioa but it is pretty complex (and more heavyweigh
In response to ProAce <[EMAIL PROTECTED]>:
> I already put the data directory on hds san storage, but there is no
> snapshot license on it.
> Could I use mksnap_ffs under freebsd to make snapshot for backup ?
Maybe. I'm confused by your question, but:
* If the data directory is on an FFS2 volume
Am Donnerstag, 2. August 2007 12:04 schrieb Andy Dale:
> Hi,
>
> You might also want to check out HA-JDBC at http://ha-jdbc.sourceforge.net
thanks for this suggestion, so i have three options to choose from:
- pgpool2
- sequoia
- ha-jdbc
Can someone share his experience on these?
kind regards
j
Hi,
You might also want to check out HA-JDBC at http://ha-jdbc.sourceforge.net
Cheers,
Andy
On 02/08/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i would like to use a statement replication for postgresql
>
> i have found the following solutions:
> - pgpool
> - pgpool2
> - sequo
Hi,
i would like to use a statement replication for postgresql
i have found the following solutions:
- pgpool
- pgpool2
- sequoia (jdbc, formerly known as c-jdbc)
pgpool has only two nodes, so this is not an option.
I will never change my underlying database, of course :-)
So i dont have any
Gregory Stark wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
A server with a GUI sitting on a login screen is wasting zero
resources. Some enterprise management tools are in java which require
a GUI to use so there is very little downside to installing X, so IMO
a lightweight window manag
Hello Developers,
your experiences with working with Free Software / Open Source projects is
needed. As part of my PhD thesis and with the goal to support the
community to
understand itself better, I am trying to find out how projects change the
way
they work over time, in particular what YO
The problem is that I can't find the way to exclude query parsing (prepare
step) for custom queries. In other words I want to create a function that
accepts a query text with "$1, $2, etc." and variables as params, executes
the query and returns a set of record. I could use 'execute' in plpgsql but
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> A server with a GUI sitting on a login screen is wasting zero
> resources. Some enterprise management tools are in java which require
> a GUI to use so there is very little downside to installing X, so IMO
> a lightweight window manager is appropria
Josh Tolley wrote:
> So please respond, if you feel so inclined, describing things you like
> to monitor in your PostgreSQL instances as well as things you would
> like to be able to easily monitor in a more ideal world.
I can think of a few things I'd like to be able to monitor...
Connection us
On 8/2/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
> What I do is install Gnome, "just in case" I need it for some reason
> (ie: opening many terminal windows at a higher res that I can alt+tab
> between).
ssh and/or screen ...
> Madi
Cheers,
Andrej
--
Please don't top post, and don't use HT
Ron Johnson wrote:
Pardon me for being the contrarian, but why does a server need a
GUI? Isn't that just extra RAM & CPU overhead that could be more
profitably put to use powering the application?
What I do is install Gnome, "just in case" I need it for some reason
(ie: opening many terminal
On 8/2/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > > I think most of the virtual memory used by X is actually the map of the
> > > graphics card's memory AFAIK, so it's not as significant as you think.
> > That machine has an on-board chipset (i845) and has only 8MB
> > shared memory allotted
59 matches
Mail list logo
