Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dmCvO-00087g-6c for pgsql-performance@arkaria.postgresql.org; Mon, 28 Aug 2017 05:49:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dmCvN-0006gz-Kr for pgsql-performance@arkaria.postgresql.org; Mon, 28 Aug 2017 05:49:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dmCtc-0003ah-9z for pgsql-performance@postgresql.org; Mon, 28 Aug 2017 05:47:36 +0000 Received: from mail-it0-x22d.google.com ([2607:f8b0:4001:c0b::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dmCt8-0001fs-S0 for pgsql-performance@postgresql.org; Mon, 28 Aug 2017 05:47:35 +0000 Received: by mail-it0-x22d.google.com with SMTP id a141so7154136itd.0 for ; Sun, 27 Aug 2017 22:47:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ndDiOi5oPiKvXh1nrw7h0RYBkuD/KYTPluDA8/O//1o=; b=pdNLw4V4IoQ1P9pgWCarSodepDenxtIdErK8JRJ+TU3BndGjvB3zNwiT6DelGAfj+w GX74FUSELzmQP8h3xO9zcN7SPeKJ6QBdkFoaiCRVbJRBqdVHd4FzirBMWG7xdvK+DRpp qhXuApGD1S3GFe+jLVIHUz8+jV00rW4oEubW4VqRWyp2Fy1rcETr03XScC2zguTss9Sj ix2gGhJrIys+yQ3IVJmbK2MfdWyjRg0rx/vp2Jb8fiZ/+m9yXsr66cwkIYNd/wK8TzbH Fbbsf+2fiqIK0ptxsXHUBya8rKSGYJJUdk4a14G+sSAQtmHzqWsF+Rm+DuEqmoP/Et7U wAKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ndDiOi5oPiKvXh1nrw7h0RYBkuD/KYTPluDA8/O//1o=; b=SL5VawQE1oBw+SiPDi1dr6tSrZadKfpGonBD0MX8m2vNX9XUh2StULQFFXTZGLyrc9 UOuBCZH5aiLks5+5rqSrSVlB8z3nv0qYYPn7fXZedZr3ocwrW10p/Q1pajargVPlBh/3 ta88fGbb2U7tFKjEU1fufXAE3bal7vSY1LIgD57eFLf65oqIgtSPkBs8ux1L2JdP/kKk CxckYF0GUb9pIsAjYb6axw/329TWGgNb8q8458iQfn4t3YkqQ78gdo7UbZkgPzY+vnkr gRfJUKScR522g2ZN1v8UGKeb3rnjTNXqY9q/sWkJfxPWOun4V+jdJxJwiYYLq4SFV1fL 7qFQ== X-Gm-Message-State: AHYfb5j11yH0DzmEmFY4GYuesDJg5NKBVkTbFsiH0p1golHoCnt5XtHz Ymry1H3nimaONU3yB9e5yON5NMHwDg== X-Received: by 10.36.23.77 with SMTP id 74mr4879709ith.100.1503899225029; Sun, 27 Aug 2017 22:47:05 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.40.213 with HTTP; Sun, 27 Aug 2017 22:47:04 -0700 (PDT) In-Reply-To: References: <88350892-C4AB-4191-9F8E-DB7CFA81F6C6@gmail.com> <00990FBB-D288-4878-8B8E-36E24F808F2C@gmail.com> From: Claudio Freire Date: Mon, 28 Aug 2017 02:47:04 -0300 Message-ID: Subject: Re: performance problem on big tables To: Mariel Cherkassky Cc: "pgsql-performance@postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Sun, Aug 27, 2017 at 1:34 PM, Mariel Cherkassky wrote: > Hi, yes indeed I'm using laurenz`s oracle_fdw extension. I tried to run it > but I'm getting error > > dbch=# ALTER FOREIGN TABLE tc_sub_rate_ver_prod OPTIONS ( SET prefetch 10240 > ); > ERROR: syntax error at or near "10240" > LINE 1: ...N TABLE tc_sub_rate_ver_prod OPTIONS ( SET prefetch 10240 ); Yeah, might need to put the 10240 in quotes. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance