On Thu, 2009-04-09 at 14:27 -0500, Bryan Murphy wrote:
> I have two hot-spare databases that use wal archiving and continuous
> recovery mode. I want to minimize recovery time when we have to fail
> over to one of our hot spares. Right now, I'm seeing the following
> behavior which makes a quick
On Fri, 2009-04-10 at 09:15 -0500, Justin Funk wrote:
> I need to be able to do full text searches on the message field, and
> of course, it needs to be reasonably fast.
>
> The table is partitioned daily and has this structure:
> My typical query looks like this:
> SELECT * FROM SystemEvents W
On Wed, 2009-04-08 at 16:06 -0400, Tom Lane wrote:
> "James B. Byrne" writes:
> > I just need another set of eyes to see whatever it is that I am
> > overlooking.
>
> The RETURN is inside the EXCEPTION clause.
>
> You really need two BEGINs here, one for the outer function body and
> one for th
On Apr 11, 2009, at 6:10 PM, li...@mgreg.com wrote:
What do you mean when you say the "catalogs...are database-
specific" ? If I'm understanding what you're saying, my whole point
is that I don't want to be tied to a database to do any kind of
querying about the PG engine itself. Does that
On Mon, 2009-04-06 at 09:57 +0200, Henry wrote:
> Is this weirdness scheduled to be addressed in 8.4, or is there some
> other hack I can try (without changing all SQL), or is the *only*
> solution to mess with existing (working) front-end code to work around
> this issue?
No, not in 8.4
I have to say, that this 'feature' also annoys me.
at least ability to update row count would be appreciated. Not to
mention proper partitioning, but that requires quite few changes in
the guts.
Currently there was a guy offering patch that adds partitioning, but
it uses built in trigger, which is
Hi,
We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3
but can't just yet. I need to run analyze periodically (like hourly),
but before I write a script to loop through the tables in each schema
and run analyze, I thought I would try autovacuum. I say one post that
said t
On 12/04/2009 17:27, Irene Barg wrote:
> We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3
> but can't just yet. I need to run analyze periodically (like hourly),
Well, the current version in that branch is 8.1.17, so you're missing a
*lot* of bug fixes. It would be worth you
On Sun, 2009-04-12 at 09:27 -0700, Irene Barg wrote:
> Hi,
>
> We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3
> but can't just yet. I need to run analyze periodically (like hourly),
> but before I write a script to loop through the tables in each schema
> and run analyz
"Raymond O'Donnell" writes:
> On 12/04/2009 17:27, Irene Barg wrote:
>> We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3
>> but can't just yet. I need to run analyze periodically (like hourly),
> Well, the current version in that branch is 8.1.17, so you're missing a
> *lot*
Hi,
I found the answer i needed in the HISTORY file that came with the
source as well as the online release notes below. I found the answer to
a few other questions as well. I will do more digging before posting in
the future.
Thank you all.
--irene
Tom Lane wrote:
"Raymond O'Donnell" wri
Good Afternoon Irene
Please keep us apprised on how your implementation progresses..
Ta Me Go Maith
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de
déni et de confidentialité
This message is confidential. If
On Sun, Apr 12, 2009 at 4:28 PM, Irene Barg wrote:
> Hi,
>
> I found the answer i needed in the HISTORY file that came with the source as
> well as the online release notes below. I found the answer to a few other
> questions as well. I will do more digging before posting in the future.
Funny thi
Hello,
I created in-memory database but the problem is all the data will
be accessed from main memory .when ever the system is restarted the entire data
that is in the tables will lost.Is there any way to dump all the data in to
local hard disk before restarting the system or any si
aravind chandu wrote:
I created in-memory database but the problem is all the
data will be accessed from main memory .when ever the system is
restarted the entire data that is in the tables will lost.Is there any
way to dump all the data in to local hard disk before restarting the
Hi ,
I have extracted postgres from postgres-noinstaller.zip file. How do
i install postgres as a service from cmd line ? Are there are any binaries
provided by postgres to install it as a service ? Please note that i am
aware that msi installer automatically does all this. I want to know
CM J wrote:
> Hi ,
>
>I have extracted postgres from postgres-noinstaller.zip file. How do
> i install postgres as a service from cmd line ?
Search: http://msdn.microsoft.com/
You can use the `net' command to start/stop services. I don't recall the
command(s) used to install them, if a
17 matches
Mail list logo
