On Mon, Jan 25, 2010 at 9:15 AM, Dino Vliet wrote:
>
> Introduction
> Today I've been given the task to proceed with my plan to use postgresql and
> other open source techniques to demonstrate to the management of my
> department the usefullness and the "cost savings" potential that lies ahead.
On 26/01/2010 12:31 AM, Joshua D. Drake wrote:
On Mon, 2010-01-25 at 09:09 -0600, Abraham, Danny wrote:
Our setup is a real valid one. Looks like it has to do more with
remote connections.
A remote connection trying to set statement_timeout on its own and
sending an invalid value.
Joshua D.
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
To get optimal performance for bulk loading you'll want to do concurrent
data loading over several connections - up to as many as you have disk
spindles. Each connection will individually be slower, but the overall
throughp
[ Send questions to pgsql-general@postgresql.org instead of
pgsql-general-ow...@postgresql.org ]
On Thu, 2010-01-21 at 13:10 -0500, Amy Smith wrote:
> how to get rid of the postmaster that is still running, but I deleted
> the $PGDATA cluster file, so it can not stop it.
> but I can not use the po
A. Kretschmer wrote:
> In response to Abraham, Danny :
> > Our setup is a real valid one. Looks like it has to do more with remote
> > connections.
>
> No. 'statement_timeout out of the valid range' has nothing to do with
> remote connections.
>
> >
> > Any idea?
>
> Show us your statement_time
Hi, Ivan:
I agree with you and also would like to 'hack' into the code. Current FTC is
the best one in database system and a great building block to support more
functions. I list some I can think about:choose "|" or "&" as an optional
parameter for to_tsquery, to_tsvector.choose normalization o
On Mon, 2010-01-25 at 15:55 -0600, Little, Douglas wrote:
> Is there a form of the revoke command that will revoke specific
> privileges from all users?
Does the CASCADE option work for you?
http://www.postgresql.org/docs/8.4/static/sql-revoke.html
You can REVOKE the privileges from the user who
Is there a form of the revoke command that will revoke specific privileges from
all users?
Thanks
Doug Little
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax
312.894.5164 | Cell 847-997-5741
do
Hi Tom,
Unfortunately, I've tried your advice, and I think that we're still in a
CPU-bound situation even after following the re-indexing and re-vacuuming.
Fortunately, though, I've just learned about a poor-man's profiler under
Linux named pstack, and it's telling me that the vacuum process is s
On Mon, 25 Jan 2010 23:35:12 +0300 (MSK)
Oleg Bartunov wrote:
> Do you guys wanted something like:
>
> arxiv=# select and2or(to_tsquery('1 & 2 & 3'));
> and2or
> -
> ( '1' | '2' ) | '3'
> (1 row)
Nearly. I'm starting from a weighted tsvector not from text/tsquery.
Do you guys wanted something like:
arxiv=# select and2or(to_tsquery('1 & 2 & 3'));
and2or
-
( '1' | '2' ) | '3'
(1 row)
Oleg
On Mon, 25 Jan 2010, Ivan Sergio Borgonovo wrote:
On Mon, 25 Jan 2010 07:19:59 -0800 (PST)
xu fei wrote:
> Hi, Oleg Bartunov:
> First th
Once again, PostgreSQL will have an exhibitors booth at this years
Southern California Linux Exposition (SCALE). I'd like to invite
everyone that will be in the area to volunteer as a booth attendant
for the dates of February 20 and 21. We'll need several persons so
that we can achieve continuous
On 01/25/2010 10:24 AM, Bob Pawley wrote:
The suggestions received have worked well for one update in the row.
However, if I make any other update on the same row the trigger fires
and more inserts are generated.
However. I have found that the 8.5 alpha version has this addition -
http://devel
The suggestions received have worked well for one update in the row.
However, if I make any other update on the same row the trigger fires and
more inserts are generated.
However. I have found that the 8.5 alpha version has this addition -
http://developer.postgresql.org/pgdocs/postgres/relea
Abraham, Danny wrote:
> ctrlm700=> show statement_timeout;
>
> statement_timeout
>
> ---
>
> 1h
I'm not sure if this is a valid value, the documentation says:
statement_timeout (integer)
Abort any statement that takes over the specified number of
milliseconds
If you re
ctrlm700=> show statement_timeout;
statement_timeout
---
1h
(1 row)
Hello Amy,
trying to understand your situation,
*I have installed a v8.4 and first port using localhost is ok - *default
port is 5432
You can only use one port for one instance of postgres, default port 5432
can be overridden by any new port number.
Thanks
Deepak
On Sun, Jan 24, 2010 at 11:23
On Mon, 25 Jan 2010 07:19:59 -0800 (PST)
xu fei wrote:
> Hi, Oleg Bartunov:
> First thanks for your quick replay. Could you explain it a little
> more on "it's general limitation/feature"? I just confuse that
> to_tsquery('item') function will return a tsquery type which is
> same as 'item'::tsqu
On Mon, 2010-01-25 at 09:09 -0600, Abraham, Danny wrote:
> Our setup is a real valid one. Looks like it has to do more with
> remote connections.
>
A remote connection trying to set statement_timeout on its own and
sending an invalid value.
Joshua D. Drake
> Any idea?
>
> Thanks
>
> Danny
>
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql and
other open source techniques to demonstrate to the management of my department
the usefullness and the "cost savings" potential that lies ahead. You can guess
how excited I am r
On Mon, Jan 25, 2010 at 04:05:57PM +0100, Stefan Schwarzer wrote:
> Guess I'd need to do this as/with postgres user/role.
Yup, or at least somebody with superuser rights. Try "\du" in psql.
> But really not
> sure how this goes. Thought it should be something like this:
>
> sudo su - po
In response to Abraham, Danny :
> Our setup is a real valid one. Looks like it has to do more with remote
> connections.
No. 'statement_timeout out of the valid range' has nothing to do with
remote connections.
>
> Any idea?
Show us your statement_timeout - setting. If you work with psql, just
Our setup is a real valid one. Looks like it has to do more with remote
connections.
Any idea?
Thanks
Danny
Hi, Oleg Bartunov:
First thanks for your quick replay. Could you explain it a little more on "it's
general limitation/feature"? I just confuse that to_tsquery('item') function
will return a tsquery type which is same as 'item'::tsquery, to my
understanding.
Let me explain what I want:First Step
But when I do this I get this error message:
Makefile:17: ../../src/Makefile.global: No such file or directory
Makefile:18: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target `/contrib/contrib-global.mk'.
Stop.
What is the problem? What
On Mon, 25 Jan 2010 12:01:04 +0100
Ivan Sergio Borgonovo wrote:
> I think I've learned how to use pg text search from Oleg and Teodor
> documentation since I've found on my code this use of setweight:
>
> query := query &&
> setweight(configuration, 'banana apple orange', 'B', '&');
>
> But I
On Mon, Jan 25, 2010 at 1:16 PM, Herouth Maoz wrote:
> Well, I assume by the fact that eventually I get an "Unexpected end of file"
> message for those queries, that something does go in and check them. Do you
> have any suggestion as to how to cause the postgresql server to do so
> earlier?
No,
Stefan Schwarzer writes:
> I deleted involuntarily my tablefunc functions in my database. Now, I
> am trying to get them back into it again. But without success.
> I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the
> Kyngchaos packages. It seems to me that before I succeeded i
Greg Stark wrote:
On Mon, Jan 25, 2010 at 11:37 AM, Herouth Maoz wrote:
The tcp_keepalive setting would only come into play if the remote
machine crashed or was disconnected from the network.
That's the situation I'm having, so it's OK. Crystal, being a Windows
application, obviously runs
On Mon, Jan 25, 2010 at 11:37 AM, Herouth Maoz wrote:
> The tcp_keepalive setting would only come into play if the remote
> machine crashed or was disconnected from the network.
>
>
> That's the situation I'm having, so it's OK. Crystal, being a Windows
> application, obviously runs on a different
Hi there,
I deleted involuntarily my tablefunc functions in my database. Now, I
am trying to get them back into it again. But without success.
I am running Mac OS X, 10.5, with postgres 8.3.1 and have used the
Kyngchaos packages. It seems to me that before I succeeded in doing
this from w
Thank you for your reply.
2010/1/25 Daniel Verite
>Alessandro Agosto wrote:
>
> > I'm not yet within select/poll cycle, this is the first call that should
> > return CONNECTION_OK or CONNECTION_BAD (refering to docs).
>
> That would be the behavior of PQconnectdb(), not PQconnectStart().
Greg Stark wrote:
On Mon, Jan 25, 2010 at 8:15 AM, Scott Marlowe wrote:
Is there a parameter to set in the configuration or some other means to
shorten the time before an abandoned backend's query is cancelled?
You can shorten the tcp_keepalive settings so that dead connections
get
On Mon, Jan 25, 2010 at 8:15 AM, Scott Marlowe wrote:
>> Is there a parameter to set in the configuration or some other means to
>> shorten the time before an abandoned backend's query is cancelled?
>
> You can shorten the tcp_keepalive settings so that dead connections
> get detected faster.
>
T
2010/1/25 Craig Ringer :
> On 25/01/2010 12:21 PM, Steeles wrote:
>>
>> As title, please help.
>> I want to setup Postgresql HA by MSCS in VMWARE platform. (win server
>> 2003, PG 8.3 on 32 bit)
>> MSCS has been setup, the problem can't start postgresql service.
>> PGDATA is on the shared disk.
>
>
I think I've learned how to use pg text search from Oleg and Teodor
documentation since I've found on my code this use of setweight:
query := query &&
setweight(configuration, 'banana apple orange', 'B', '&');
But I can't find any trace of this use in official postgres docs.
The docs just says:
On 25/01/2010 5:29 PM, Adrian von Bidder wrote:
On Monday 25 January 2010 08.25:30 John R Pierce wrote:
My question is, which is more efficient? Performance-wise, does it
matter whether unchanged fields are included or omitted on UPDATE
statements
my first order guess is, sending and having to
On 25/01/2010 12:21 PM, Steeles wrote:
As title, please help.
I want to setup Postgresql HA by MSCS in VMWARE platform. (win server
2003, PG 8.3 on 32 bit)
MSCS has been setup, the problem can't start postgresql service.
PGDATA is on the shared disk.
Are you trying to share a PostgreSQL data di
Scott Marlowe wrote:
You can shorten the tcp_keepalive settings so that dead connections
get detected faster.
Thanks, I'll ask my sysadmin to do that.
Might be, but not very likely. I and many others run pgsql in
production environments where it handles thousands of updates /
inserts per
Hi all.
I'd like to know how is inheritance handled when the number of child
tables grows and
I'm accessing (actually SELECTing from) the master, possibly with
contraint exclusion enabled.
How does grow then planner time and the query execution time for such
queries when
the number of children i
On Monday 25 January 2010 08.25:30 John R Pierce wrote:
> > My question is, which is more efficient? Performance-wise, does it
> > matter whether unchanged fields are included or omitted on UPDATE
> > statements
>
> my first order guess is, sending and having to parse the additional
> unchanged f
2010/1/25 Vincenzo Romano :
> 2010/1/25 Pavel Stehule :
>> 2010/1/25 Vincenzo Romano :
>>> 2010/1/23 Pavel Stehule :
2010/1/22 Vincenzo Romano :
> 2010/1/22 Tom Lane :
>> Vincenzo Romano writes:
>>> 2010/1/22 Tom Lane :
regression=# CREATE FUNCTION q( fmt text, variadic a
Hi,
Please have a look at the functions also - what are they doing? In Oracle
I have come across a situation where a lot of redo log was generated
because one SQL was updating an entire table, instead of a few selected
records. Since the new data was the same as the old data (for records
which
2010/1/25 Pavel Stehule :
> 2010/1/25 Vincenzo Romano :
>> 2010/1/23 Pavel Stehule :
>>> 2010/1/22 Vincenzo Romano :
2010/1/22 Tom Lane :
> Vincenzo Romano writes:
>> 2010/1/22 Tom Lane :
>>> regression=# CREATE FUNCTION q( fmt text, variadic args "any" )
>
>> And this wou
As title, please help.
I want to setup Postgresql HA by MSCS in VMWARE platform. (win server 2003,
PG 8.3 on 32 bit)
MSCS has been setup, the problem can't start postgresql service.
PGDATA is on the shared disk.
I tried generic service, and application, either one won't bring up
postgresql data
On Sun, Jan 24, 2010 at 3:17 AM, Herouth Maoz wrote:
> Hi Everybody.
>
> I have two questions.
>
> 1. We have a system that is accessed by Crystal reports which is in turned
> controlled by another (3rd party) system. Now, when a report takes too long or
> the user cancels it, it doesn't send a ca
46 matches
Mail list logo
