hat are you trying to achieve?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t TAR file will be compressed, it has
nothing to do with the data transfered from the server.
If you want to compress the data sent over the network, use
pg_basebackup over an SSL connection with SSL compression enabled.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general
When I run a select on pg_settings with these two users I recieve different
> results.
That is intentional, because some settings should only be
visible for superusers, for example everything that has to
do with the operating system (location of configuration file
or socket directories).
Your
Do determine what is going on, EXPLAIN (ANALYZE, BUFFERS) output
would be useful.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
if checkpoint_completion_target is 0.9, spending 0.9 * 3600 = 3240
seconds
per hour doing checkpoints would be normal.
The whole point of this parameter is to spread checkpoints across
a longer time to avoid I/O spikes.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-gener
h the same
OID
in the second database.
I'd restore the large objects and manually fix all collisions
(import the problematic large objects with a different OID and adjust
the referencing tables accordingly).
This might prove difficult if there are a lot of collisions, but I don't
nux-gnu, compiled by gcc (Ubuntu
> 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
PostgreSQL did not complain about an index being zeroed, it just
says it can't find a certain page (which probably never existed).
The missing CLOG entries are probably just an effect of data
corru
e all optimizer database parameters identical?
Also, to have PostgreSQL inline the function, which would be good
for performance, it should be declared IMMUTABLE.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
591)
> Index Cond: ((m.chrom = 22) AND (m.basepos >= s.startbase) AND
(m.basepos <= s.endbase))
I think your biggest problem is the join condition
on m.basepos between s.startbase and s.endbase
That forces a nested loop join, which cannot be performed efficiently.
Yours,
La
the sort
order necessary for the merge join.
It uses a filter to only return the interesting rows.
The number is indeed surprising.
I *assume* that it refers to numbers eliminate from the merge join result,
but that's only guessing.
> The materialize returns 184791 rows. This one I und
y to publish my binaries of the extension if I ever get
> that far.
> Can anyone help?
Based on my experience with oracle_fdw, I would change the function declaration
in tds_fdw.h to
extern PGDLLEXPORT Datum tds_fdw_handler(PG_FUNCTION_ARGS);
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ion that brings the "materialized view"
up to date.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ittle information.
If there is nothing suspicious in the log, and hot standby is enabled,
and the standby is configured appropriately, it could be that a conflicting
query on the standby block WAL application for a while.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@p
Brahmam Eswar wrote:
> How to migrate the Oracle collection types ( IsTableOF, IsRecord) to postgres.
Are you talking about table definitions or PL/SQL code?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
NVOICE_NUM%TYPE,
> TXN_CNT NUMBER
>);
You can create a composite type in PostgreSQL:
CREATE TYPE complex AS (r integer, i integer);
>TYPE INV_LINES_T IS TABLE OF INV_LINES_RT;
You would use an array in this case:
DECLARE
carr complex[];
Yours,
Laurenz Albe
--
Sent v
15 matches
Mail list logo
