r a query, you can use tools
like pg_activity of pg_view to monitor it.
And if you are using postgres 9.4 or more, you can also use
pg_stat_statement and pg_stat_kcache extensions to get actual disk reads
and writes for all normalized queries.
Regards.
> Cheers,
>
> Jeff
--
Julie
zed
> that upper doesn't consistently work the way I expected. Of course
> my assumptions are probably wrong so that's why I'm asking for
> clarification.
>
Because for discrete range types, the canonical form is used, which is
[). Check
http://www.postgresql.org/docs/current/
pg.darold.net/
>
> We've done several client migrations with it, quite successfully
>
>
>
ora2pg is definitely the tool you need. It can give you a total
migration estimated time (in man-day unit), with a call like
ora2pg -c ora2pg.conf -t SHOW_REPORT --dump_as_html --estim
al_level = minimal:
"In minimal level, WAL-logging of some bulk operations can be safely
skipped, which can make those operations much faster"
see http://www.postgresql.org/docs/current/static/runtime-config-wal.html
> So is option 2 a winner by design? Could you please su
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 14/07/2015 18:21, Igor Stassiy wrote:
> Julien, I have the following setting for WAL level: #wal_level =
> minimal (which defaults to minimal anyway)
>
> On Tue, Jul 14, 2015 at 6:19 PM Julien Rouhaud
> mailto:julien.rouh...@dalib
;s hard to help you much more.
If you don't care about losing data on this table if your server
crashes, you can try option #3 with an unlogged table.
> On Tue, Jul 14, 2015 at 6:19 PM Julien Rouhaud
> mailto:julien.rouh...@dalibo.com>> wrote:
>
> On 14/07/201
ttp://www.postgresql.org/docs/current/static/sql-createtable.html
and the "UNLOGGED" part to check if an unlogged table is suitable for you.
>
> On Tue, Jul 14, 2015 at 6:37 PM Julien Rouhaud
> mailto:julien.rouh...@dalibo.com>> wrote:
>
> On 14/07/2015 18:21, Igor Sta
rcode, o1.oprnegate, o2.oprname as negate from
pg_operator o1 join pg_operator o2 on o1.oprnegate = o2.oid where
o1.oprname = '=' and o1.oprleft = 'int8'::regtype and o1.oprright =
'int8'::regtype;
oprname │ oprcode │ oprnegate │ negate
═╪═╪
https://github.com/anse1/sqlsmith), which works
very well.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 29/09/2016 23:23, Vinicius Segalin wrote:
> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <mailto:julien.rouh...@dalibo.com>>:
> You should try sqlsmith (https://github.com/anse1/sqlsmith
> <https://github.com/anse1/sqlsmith>), which works
> very well.
&
aints
> * Primary Keys
> * Foreign keys
> * Rules and Triggers
>
you can specify a "NO INHERIT" on the check constraint, that should
solve your issue.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
>>> Limit (cost=0.00..277.35 rows=10 width=83) (actual
>>> time=0.111..75.549 rows=10 loops=1)
>>>-> Seq Scan on mytable (cost=0.00..381187.45 rows=1
in/psql --dbname=doom --username=doom
> doom=# select 'world' as hello;
> select 'world' as hello;
> hello
>---
> world
>(1 row)
> [...]
> I'm running out of ideas for things to check. Any suggestions?
>
Any unusual
https://github.com/dalibo/db2topg
The README should provide all needed informations.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
resql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html
(This link is available in the "Yum Howto" section of yum.postgresql.org)
Last time I tried it worked as intended.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent
his bugfix is not enough or if you find other issues, could you report them
directly on github (https://github.com/darold/ora2pg/issues)?
Thanks!
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Dec 12, 2016 at 04:15:59PM +, Joanna Xu wrote:
> On Fri, Dec 11, 2016 12:43 PM, Julien Rouhaud wrote:
> >>I forwarded your mail to the author, since he's not on this mailing-list.
> >>This issue should be fixed with commit
> >>>&g
; archives), save it locally, and then open it in your email client, you
> can then hit "reply-all".
>
> HTH,
>
> Joe
>
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ation, use or reliance upon this information by unintended
> recipients is prohibited. Any opinions expressed in this email are
> those of the author personally.____
>
>
>
> This message and any attachments have been scanned for viruses prior
> leaving PAY
n.html
Regards.
> Any help will be greatly appreciated. Thanks.
>
> Best Regards.
>
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 19/03/2016 15:58, Julien Rouhaud wrote:
> Hello,
>
> On 19/03/2016 15:41, Yi, Yi wrote:
>> Hello,
>>
>> I had an issue with the behavior of pg_basebackup command. I was convinced
>> previously that pg_basebackup command always made the binary copy of the
indisunique) and exclusion constraint (indisexclusion)
indexes should also be excluded, and also probably indexes used to
cluster tables (indisclustered).
You should also check since when the idsx_scan and other counters are
aggregating before dropping any index. Check
pg_stat_get_d
or key-value storage solution in the pg code?
> if so, please point me to the right part of the source.
>
Yes, there's an hashtable implementation, see dynahash.c
If you want to use that in shared memory in your extension, you can look
at the pg_stat_statements extension (look for pgss_ha
n you of missing dependancy if any.
You can also refer to the installation documentation (
https://github.com/dalibo/powa/blob/master/README.md).
Regards.
--
Julien Rouhaud
http://www.dalibo.com
ments.c how it's done (_PG_INIT() and
pgss_shmem_startup()).
Asking a small amount probably works because some shared memory is requested
but not totally used as soon as the server starts.
Regards.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-
afraid. You could also try on a postgres build having
LWLOCK_STATS defined.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t; *" LWLockPadded *lwLockPadded = GetNamedLWLockTranche("Some_10_LWLocks");
>LWLock *lock = &(lwLockPadded[index in 0 to 9]).lock; "*
>
> Is the above code snippet a valid for requesting some 10 LWLocks?
>
>
AFAIK yes this is the correct way to use multiple lwl
On 03/05/2017 15:01, hariprasath nallasamy wrote:
>
> AFAIK yes this is the correct way to use multiple lwlocks.
>
>
> Thanks.!
>
> Just curious, Is there any other way to do this.?
Probably no, except asking for 10 different tranches :)
--
Julien Rouhaud
htt
ou want more details, you can either look at the code or open an
issue on the repo (https://github.com/darold/ora2pg/).
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
On Thu, Aug 10, 2017 at 6:41 AM, Michael Paquier
wrote:
> On Thu, Aug 10, 2017 at 6:23 AM, anand086 wrote:
>> I was looking for a way to maintain historical query details in Postgres to
>> answer questions like
>>
>> What was the sql call rate between time X and Y?
>> Did the execution count incr
On Thu, Aug 10, 2017 at 3:00 PM, Melvin Davidson wrote:
>
> If you are interested in historical stats, you would probably fair a lot
> better with PgBadger. It is free
> and highly customizable. In addition to SQL call rates at different times,
> it provides analysis of
> most used queries, slo
Hi everyone,
Is there an easy way (that I maybe missed) to use constraint exclusion with
2 floats ?
Must I find an extension the temporal extension which create a new type with
2 timestamp or can I usethe && operator with 2 fields ?
Thank you
ething similar or if there's is an easier way
On Wed, Oct 12, 2011 at 11:23 PM, Simon Riggs wrote:
> On Wed, Oct 12, 2011 at 10:16 AM, Julien Rouhaud
> wrote:
> > Hi everyone,
> > Is there an easy way (that I maybe missed) to use constraint exclusion
> with
> > 2
As there's one file for each object, a single update on each would make you
to copy the all the file again. I heard there was tool to make differentiel
copy of a part of a file but I don't know if it's really efficient.
Anyway, a better way for you would be to do a regular backup (with
pg_start_ba
On Thu, Oct 13, 2011 at 12:04 AM, Bob Hatfield wrote:
> > Anyway, a better way for you would be to do a regular backup (with
> pg_start_backup, copy and pg_stop_backup) and then use wal archive_command
> to keep the xlogs between 2 full backups.
>
> Thanks Julien. Can pg_start/stop_backup() be us
On Fri, Oct 14, 2011 at 6:38 PM, Carlos Mennens wrote:
> I've configured my 'pg_hba.conf' file to look as follows:
>
> # "local" is for Unix domain socket connections only
> local all all md5
> # IPv4 local connections:
> hostall all 127.
On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens wrote:
> I'm confused about how I'm able to access the following pg_* tables
> regardless of connected database. I thought these tables were hidden
> or stored in the 'postgres' database but I'm still able to access this
> data regardless of which da
On Fri, Oct 14, 2011 at 6:57 PM, Julien Rouhaud wrote:
> On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens
> wrote:
>
>> I'm confused about how I'm able to access the following pg_* tables
>> regardless of connected database. I thought these tables were hidde
On Wed, Jun 6, 2012 at 6:28 PM, Tom Lane wrote:
> Frank Lanitz writes:
> > Am 06.06.2012 17:49, schrieb Tom Lane:
> >> For me, pg_database_size gives numbers that match up fairly well with
> >> what "du" says. I would not expect an exact match, since du probably
> >> knows about filesystem over
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka wrote:
> Hi,
>
> I m trying to take backup of data of a particular table using pg_dump.
> I used double quotes for table name but output is :
> pg_dump : no tables were found.
>
> Command used :
> -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTa
40 matches
Mail list logo
