Re: SeqScan vs. IndexScan

Vitaliy Garnashevich writes: > I'm running the same query with "set enable_seqscan = on;" and "set > enable_seqscan = off;": > ... > Why optimizer is choosing SeqScan (on cmn_user) in the first query, > instead of an IndexScan, despite of SeqScan being more costly? Because it cares about the to

SeqScan vs. IndexScan

Hi, I'm running the same query with "set enable_seqscan = on;" and "set enable_seqscan = off;": ->  Nested Loop Left Join  (cost=0.00..89642.86 rows=1 width=30) (actual time=1.612..6924.232 rows=3289 loops=1)   Join Filter: (sys_user.user_id = j_6634.id)   Rows Removed by Join Filter

Re: pg_upgrade help

Hi Both version should be correctly stopped. pg_upgrade started clusters itself. Please check pg_upgrade_server.log file in directory where pg_upgrade was run. Also where is postgresql.conf? In PGDATA? Otherwise you need tell pg_upgrade correct path, for example with options '-o " -c config_file=

RE: Data migration from postgres 8.4 to 9.4

Hi, pg_upgrade does not need installation, it comes with a PostgreSQL installation. You will find it in the bin directory of your 9.4 PostgreSQL installation. Best Regards, Nawaz Ahmed Software Development Engineer Fujitsu Australia Software Technology Pty Ltd 14 Rodborough Road, Frenchs For

RE: Installing PostgreSQL 9.5 in centos 6 using YUM

Hi, could you wget it and try installing instead ? or could you try an rpm that matches with your exact CentoOS version from here. https://download.postgresql.org/pub/repos/yum/9.5/redhat/ Best Regards, Nawaz Ahmed Software Development Engineer Fujitsu Australia Software Technology Pty Ltd 1

pg_upgrade help

Hi all, I need help on pg_upgrade from 8.4 to 9.4 version. Appreciate urgent response. Installed both version and stopped it. Do i need to run both version or only one 8.4 or 9.4 . Both should run on 50432 ? -bash-4.2$ id uid=26(postgres) gid=26(postgres) groups=26(postgres) context=unconfined