Tom, thanks for the quick reply.
Unfortunately, rebuilding the backup server from the master is not really
an option at this point. This is a fairly large database (~1TB), are there
any other options that will allow us to get the backup server to ingest WAL
files without database corruption?
Tha
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Lutz Fischer
> Sent: Monday, April 29, 2013 1:52 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Windows query weird result
>
> Hi,
>
> had a bit of wei
On 04/29/2013 12:13 PM, Rowan Collins wrote:
This is the same basic plan as the test case, but with the tables in a
slightly different order (this has the offers table joined last, where
the test data joins the mapping table last).
Tom already explained this much better than I could. But the k
Hi,
had a bit of weird result for a query:
SELECT id FROM spectrum_match WHERE search_id in (788,694,693,685) AND
rescored IS NOT NULL and dynamic_rank = true ORDER BY ID;
returns (among some 127K other lines):
...
32694548
32694860
...
But if I change the query to:
SELECT id FROM spectrum_match
On 29/04/2013 17:04, Shaun Thomas wrote:
> On 04/26/2013 09:39 AM, Rowan Collins wrote:
>> If I run "ANALYZE temp_fares_mappings;" - the table which is being
>> Updated, and is the outermost in the query plan - the problem goes
>> away *even though the Query Plan hasn't changed*.
>
> Oh, but it ha
Rowan Collins writes:
> I've come upon some very strange behaviour with an UPDATE query which
> causes Postgres to consume all the disk space on the server for no
> apparent reason.
The short answer to that is "analyze your data". Particularly when
you're using temp tables, for which auto-anal
On 04/26/2013 09:39 AM, Rowan Collins wrote:
If I run "ANALYZE temp_fares_mappings;" - the table which is being
Updated, and is the outermost in the query plan - the problem goes
away *even though the Query Plan hasn't changed*.
Oh, but it has.
The query plan pre-analyze:
Update on test_map
On 26 April 2013 15:39, Rowan Collins wrote:
> Hi All,
>
> I've come upon some very strange behaviour with an UPDATE query which causes
> Postgres to consume all the disk space on the server for no apparent reason.
>
> Basically, I'm trying to run an UPDATE involving three medium-sized tables
> (~
thanks!
i also see that it's available from apt.postgresql.org, including lots of
postgres versions!
WBL
On Mon, Apr 29, 2013 at 1:01 PM, Marko Kreen wrote:
> On Mon, Apr 29, 2013 at 12:25:15PM +0200, Willy-Bas Loos wrote:
> > I want to upgrade from londiste2 to londiste3.
> > Skytools 2 has
On Mon, Apr 29, 2013 at 12:25:15PM +0200, Willy-Bas Loos wrote:
> I want to upgrade from londiste2 to londiste3.
> Skytools 2 has a -modules- package.
> We're using postgres 8.4 at the moment, so we use the package
> skytools-modules-8.4.
>
> Now i'm looking at londiste3 in Debian experimental, bu
Hi,
I want to upgrade from londiste2 to londiste3.
Skytools 2 has a -modules- package.
We're using postgres 8.4 at the moment, so we use the package
skytools-modules-8.4.
Now i'm looking at londiste3 in Debian experimental, but there are no
'modules' packages. Don't i need one anymore?
(hope this
Simon Riggs, 28.04.2013 21:42:
On 21 April 2013 12:17, Thomas Kellerer wrote:
DB2 lets you define your own types (just as Postgres) but with the added
benefit that you can mark them such that they are _not_ comparable, e.g. to
avoid comparing "apples to oranges".
Sounds like an interesting f
12 matches
Mail list logo
