On Wed, Jan 28, 2009 at 2:10 AM, Abdul Rahman wrote:
> Thanks Jaime,
> Plz consider the actual log files to explore the issue in detail. Because I
> have pasted the log files of client machine, I am using (sorry).
>
>
> 2009-01-27 18:29:25 STATEMENT: delete from ci_cin_type_v where
> req_id='0824
Very nice!
Most probably it was waiting for something else. This is the reason the query
executed today and clearly showed certain number of rows deleted. But what ELSE?
From: Sim Zacks
To: Abdul Rahman
Sent: Wednesday, January 28, 2009 12:08:28 PM
Subject:
Thanks Jaime,
Plz consider the actual log files to explore the issue in detail. Because I
have pasted the log files of client machine, I am using (sorry).
2009-01-27 18:29:25 STATEMENT: delete from ci_cin_type_v where
req_id='0824100207'
delete from ci_cust_type_v where req_id='0824100207
On Wed, Jan 28, 2009 at 1:29 AM, Abdul Rahman wrote:
> Welcome Jcasanov,
>
> Here is the output of the log files:
>
> 2009-01-27 09:24:18 FATAL: the database system is starting up
> 2009-01-27 09:24:19 LOG: database system was shut down at 2009-01-26
> 18:34:53
> 2009-01-27 09:24:19 LOG: checkp
Welcome Jcasanov,
Here is the output of the log files:
2009-01-27 09:24:18 FATAL: the database system is starting up
2009-01-27 09:24:19 LOG: database system was shut down at 2009-01-26 18:34:53
2009-01-27 09:24:19 LOG: checkpoint record is at 0/1B9F92C8
2009-01-27 09:24:19 LOG: redo record i
On Wed, Jan 28, 2009 at 12:56 AM, Abdul Rahman wrote:
>
> What do the logs show?
>
> Message just showed the time it took to delete certain number of records.
>
can you show that message? copy 'n pasted from logs!!
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y d
On Wed, Jan 28, 2009 at 12:19 AM, Abdul Rahman wrote:
> Dear All,
>
> PostgreSQL does not perform rollback action. Is it true?
>
no. postgresql executes all statements that are outside an explicit
transaction in its own implicit one [1] executing commit at the end,
if you cancelled the query the
Thanks Justin,
Answers of your technical
questions are as under:
What does the sql statement look like?
delete from ci_cif_v where
req_id='0824100207';
Where was the statement run?
On SQL pan of pgAdmin-III
How was the statement killed?
By
clicking the Cancel Query button ->
What do the logs show?
Abdul Rahman wrote:
Dear All,
Yesterday I canceled a running query because it was taking long time
(more than 12 minutes) to delete lots of records. Today when I
executed the same query it hardly took few seconds to finish. It
clearly explores that PostgreSQL does not perform rollback actio
Dear All,
Yesterday I canceled a running query because it was taking long time (more than
12 minutes) to delete lots of records. Today when I executed the same query it
hardly took few seconds to finish. It clearly explores that PostgreSQL does not
perform rollback action. Is it true?
Regards,
Hi Richard,
I'm available to volunteer for a couple of hours or so. Let me know what time
slots you're looking to cover.
Thanks!
-Noel
- Original Message -
From: Richard Broersma
Sent: Mon, 1/26/2009 12:09pm
To: Los Angeles PostgreSQL Users Group
Cc: PostgreSQL General
Subject: [lapu
Hi,
On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien wrote:
> Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> longer.
Are you disabling full_page_writes? It may slow down recovery several times.
> Thanks I will take a look at it. Also, I came across the record log shipping
On Tue, Jan 27, 2009 at 05:30:23PM -0500, Tom Lane wrote:
> Karsten Hilbert writes:
> > the explain analyze of which is (I've actually gotten it to
> > work better in the meantime as you can see):
>
> Looks like most of the problem is in the subquery scans on v_staff,
> which seems to be a rathe
Karsten Hilbert writes:
> the explain analyze of which is (I've actually gotten it to
> work better in the meantime as you can see):
Looks like most of the problem is in the subquery scans on v_staff,
which seems to be a rather expensive view :-(. Maybe you can
simplify that a bit.
On Tue, Jan 27, 2009 at 04:42:02PM -0500, Tom Lane wrote:
> What does EXPLAIN ANALYZE say about it? Also, what is the use-case
> you are concerned about --- selecting the whole view contents, or
> selecting WHERE something-or-other?
Oh, and the use case is to select all the test_results which
be
On Tue, Jan 27, 2009 at 04:42:02PM -0500, Tom Lane wrote:
> Karsten Hilbert writes:
> > The view in question is in fact a lot more complicated. This
> > is the best I've been able to come up with so far (and it is
> > still slow - slow as in 3-4 seconds for 20 records out of
> > (currently only)
Karsten Hilbert writes:
> The view in question is in fact a lot more complicated. This
> is the best I've been able to come up with so far (and it is
> still slow - slow as in 3-4 seconds for 20 records out of
> (currently only) 50 !):
What does EXPLAIN ANALYZE say about it? Also, what is the us
On Tue, 2009-01-27 at 14:28 -0500, Gabi Julien wrote:
> Could this help? If the logs are smaller then I could potentially afford
> shipping then at a higher frequency.
>
See if there are times during which the recovery process isn't doing
anything (i.e. just waiting for WAL data). If so, somethi
On Tue, Jan 27, 2009 at 06:48:11PM +, Sam Mason wrote:
> > table test_results
> > modified_by integer foreign key staff(pk),
> > intended_reviewer integer foreign key staff(pk),
> > actual_reviewer integer foreign key staff(pk)
> >
> > (this table will contain millions of rows)
>
On Tuesday 27 January 2009 13:13:32 you wrote:
> On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> > I have merged the last hot standby patch (v9g) to 8.4 devel and I am
> > pleased with the experience. This is promising stuff. Perhaps it is a bit
> > too soon to ask questions here but here
On Jan 27, 2009, at 7:12 PM, Karsten Hilbert wrote:
Hello all,
maybe some general advice can be had on this:
table test_results
modified_by integer foreign key staff(pk),
intended_reviewer integer foreign key staff(pk),
actual_reviewer integer foreign key staff(pk)
(th
On Tue, Jan 27, 2009 at 07:12:05PM +0100, Karsten Hilbert wrote:
> Hello all,
>
> maybe some general advice can be had on this:
>
> table test_results
> modified_by integer foreign key staff(pk),
> intended_reviewer integer foreign key staff(pk),
> actual_reviewer integer foreig
On Jan 26, 2009, at 2:09 PM, Phoenix Kiula wrote:
I wonder if this is an SQL limitation or something I'm missing in the
PG manual, but I need to run an update on my database (to replace the
value of a column to match a new design structure).
Easiest is probably to add a new column for the new
On Jan 26, 2009, at 4:41 AM, Phoenix Kiula wrote:
Appreciate any thoughts.
My query is:
explain analyze SELECT
testimonials.url
,testimonials.alias
,testimonials.aliasEntered
,testimonials.title
,testimonials.modify_date
,testi
typo sorry
justin wrote:
Karsten Hilbert wrote:
Hello all,
maybe some general advice can be had on this:
table test_results
modified_by integer foreign key staff(pk),
intended_reviewer integer foreign key staff(pk),
actual_reviewer integer foreign key staff(pk)
(this table will c
Karsten Hilbert wrote:
Hello all,
maybe some general advice can be had on this:
table test_results
modified_by integer foreign key staff(pk),
intended_reviewer integer foreign key staff(pk),
actual_reviewer integer foreign key staff(pk)
(this table will contain millions
On Jan 25, 2009, at 3:07 AM, Jasen Betts wrote:
I want to use this column as a foreign key on a column in another
table
(column 2), but cannot without a full unique index.
a full unique index is easy use an expression that's null for -1.
create unique index foobar on foo( ( case fee when -1
On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff. Perhaps it is a bit too soon to
>
> ask questions here but here it is:
>
> 1. Speed of recovery
>
> With a arch
On Tue, Jan 27, 2009 at 11:26:13AM -0500, Markova, Nina wrote:
> > I am in process of learning psql. I'm trying to extract information
> > about tables - as many details as possible. Something similar to what
> > I'm used to see using Ingres RDBMS
Postgres and Ingres are different database engine
Hello all,
maybe some general advice can be had on this:
table test_results
modified_by integer foreign key staff(pk),
intended_reviewer integer foreign key staff(pk),
actual_reviewer integer foreign key staff(pk)
(this table will contain millions of rows)
table staff
On Tue, 2009-01-27 at 12:58 -0500, Merlin Moncure wrote:
> you can manually throw pg_switch_xlog(), In practice, this is more of
> an issue on development boxes than anything if you server is at all
> busy.
>
That won't speed up recovery, that will just force the WAL segment to be
archived. It's
1. Speed of recovery
With a archive_timeout of 60 seconds, it can take about 4 minutes before I see
the reflected changes in the replica. This is normal since, in addition to
the WAL log shipping, it takes more time to do the recovery itself. Still, is
there any way besides the archive_timeout
On 1/27/09, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff. Perhaps it is a bit too soon to
> ask questions here but here it is:
>
> 1. Speed of recovery
>
> With a archive_timeout of 60 seconds,
Hello all.
I have a problem and tech support at troll tech has been unable to help
me resolve. I am trying to compile libpq.lib from postgresql 8.3.5
into QT's version 4.4.3 qsqlpsql.dll. using Visual Studio 2008
Built libpq.lib and libpq.dll with no problesm using nmake.
Now comes time t
I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
with the experience. This is promising stuff. Perhaps it is a bit too soon to
ask questions here but here it is:
1. Speed of recovery
With a archive_timeout of 60 seconds, it can take about 4 minutes before I see
th
No matter if I drop the trigger that update agg content and the fact
that I'm just updating d, postgresql will update the index?
Yes, due to MVCC. Update of row could produce new version (tuple) and new
version should be index as old one.
--
Teodor Sigaev E-mail
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
sorry, I don't know norwegian, what do you mean ? Did you complain that
no_ispell doesn't recognize these words ?
Yes, I'm sorry, I should have explained better.
The words hemsedalsdans, hengesmykke and l?rdalsbrua, are "concatenations" of
the words
On Tue, 2009-01-27 at 05:55 +0100, db.subscripti...@shepherdhill.biz
wrote:
> I have a table with BIG SERIAL field as Primary KEY. During high load,
> entries in the BIG SERIAL field are jumped. One could see a row with
> 1367 and expecting the next INSERT to be 1368, one would end up
> getting 13
> Hi,
>
> I am in process of learning psql. I'm trying to extract information
> about tables - as many details as possible. Something similar to what
> I'm used to see using Ingres RDBMS - table structure, creation date,
> number of rows, primary keys, is it journalled, etc. In Ingres in
> order
Thanks for elaborating on that Tom. I understand what it means by extension
now.
The reason I looked into it in the first place was because someone at work
said that varchar was an alias for text, which didn't quite sound right.
And I had automatically used the data-type "text" for any varying te
Oleg Bartunov wrote:
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
Tommy Gildseth wrote:
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell
Thom Brown writes:
> The reason I ask is because the documentation says "If character varying is
> used without length specifier, the type accepts strings of any size. The
> latter is a PostgreSQL extension." I wasn't sure if such an extension meant
> there was a level of over-head involved, or r
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
Tommy Gildseth wrote:
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell,
probably
has bette
Tommy Gildseth wrote:
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell,
probably
has better support of composite words.
Thanks, tha
On Tue, Jan 27, 2009 at 1:16 PM, Magnus Hagander wrote:
> For example, consider what happens when your files are on a roaming
> profile. And yes, profiles can more or less randomly move between being
> roaming and local-copy in my experience... And you really don't want
> that for your database f
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell,
probably
has better support of composite words.
Thanks, that knocked me onto the r
Holger Hoffstaette wrote:
> On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote:
>
>> Holger Hoffstaette wrote:
>>> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
>>>
I'm not sure which directory should we create $PGDATA -- "My Documents",
"Application Data", "Local Se
On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote:
> Holger Hoffstaette wrote:
>> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
>>
>>> I'm not sure which directory should we create $PGDATA -- "My Documents",
>>> "Application Data", "Local Settings" or direct child of %USERPR
Hi for all!
It's aviable to download de VDI image of the distro pglive[1] made by
R. Bernier.
To use it, you only need a VirtualBox running on your machine.
It have more features like pyreplica, pgdevel84 (one of the last
snapshots), bucardo
on others.
The link is http://www.quesapa.com.ar/pgsq
Harald Armin Massa wrote:
> THE MORE hurting problem on Windows7 is the inability to start the
> postgresql service. There must have been some changes to the service
> framework / security
> "security" which prevend the startup...
Dave Page just posted a patch for that, so we'll hopefully have it
On Tue, Jan 27, 2009 at 12:18 PM, Harald Armin Massa
wrote:
> THE MORE hurting problem on Windows7 is the inability to start the
> postgresql service. There must have been some changes to the service
> framework / security
> "security" which prevend the startup...
I posted a patch for that to -h
Holger,
>>> 4.) it seems to be no longer "cool" to have your data below Program
>>> Files / Program Files (x86)
> That was never cool or good practice.
Yes, we discussed that on pg-installer some time ago. But we were in
good bad company, as Microsoft SQL Server and Exchange did similiar
things.
Holger Hoffstaette wrote:
> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
>
>> I'm not sure which directory should we create $PGDATA -- "My Documents",
>> "Application Data", "Local Settings" or direct child of %USERPROFILE%, but
>> anyway some of them would be better than "Program F
On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
> Harald Armin Massa wrote:
>
>> 4.) it seems to be no longer "cool" to have your data below Program
>> Files / Program Files (x86)
That was never cool or good practice.
> I'm not sure which directory should we create $PGDATA -- "My D
Thank you, Merlin and Asko for your responses :-) Because my whole project
is using PL/Proxy I should have realised I could use that instead of dblink
in this case.
Thanks again,
- Ian
2009/1/26 Asko Oja
> Take a stab at plproxy if you want to remotly call functions. Should be
> much better
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell, probably
has better support of composite words.
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
Oleg Bartunov wr
Oleg Bartunov wrote:
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
I'm trying to figure out how to use PostgreSQL's fulltext search with
an ispell dictionary. I'm having a bit of trouble figuring out where
this norwegian.dict comes from though.
When I install the norwegian ispell dictionary, i ge
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm using posgresql 8.2.4 on Gentoo Linux.
Is there anything that can be done about an infinite loop in plpython?
I tired stopping the query (with PG Admin), but the process kept going
on the server. I tried pg_cancel_backend but it kept running. I tr
I see. Thanks for clarifying!
Thom
2009/1/27 Richard Huxton
> Thom Brown wrote:
> > The reason I ask is because the documentation says "If character varying
> is
> > used without length specifier, the type accepts strings of any size. The
> > latter is a PostgreSQL extension." I wasn't sure i
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
I'm trying to figure out how to use PostgreSQL's fulltext search with an
ispell dictionary. I'm having a bit of trouble figuring out where this
norwegian.dict comes from though.
When I install the norwegian ispell dictionary, i get 4 files, nb.aff,
nb
Andreas Wenk wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tommy Gildseth schrieb:
I'm trying to figure out how to use PostgreSQL's fulltext search with an
ispell dictionary. I'm having a bit of trouble figuring out where this
norwegian.dict comes from though.
When I install the norwegia
Thom Brown wrote:
> The reason I ask is because the documentation says "If character varying is
> used without length specifier, the type accepts strings of any size. The
> latter is a PostgreSQL extension." I wasn't sure if such an extension meant
> there was a level of over-head involved, or red
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tommy Gildseth schrieb:
> I'm trying to figure out how to use PostgreSQL's fulltext search with an
> ispell dictionary. I'm having a bit of trouble figuring out where this
> norwegian.dict comes from though.
> When I install the norwegian ispell dictio
I'm trying to figure out how to use PostgreSQL's fulltext search with an
ispell dictionary. I'm having a bit of trouble figuring out where this
norwegian.dict comes from though.
When I install the norwegian ispell dictionary, i get 4 files, nb.aff,
nb.hash, nn.aff and nn.hash. What I'm unable to
The reason I ask is because the documentation says "If character varying is
used without length specifier, the type accepts strings of any size. The
latter is a PostgreSQL extension." I wasn't sure if such an extension meant
there was a level of over-head involved, or reduced its indexability.
20
Is there a real difference between a varchar without a specified length and
the text datatype?
66 matches
Mail list logo
