Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dmCz6-0008Ka-Ln for pgsql-performance@arkaria.postgresql.org; Mon, 28 Aug 2017 05:53:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dmCz5-0001Tz-R2 for pgsql-performance@arkaria.postgresql.org; Mon, 28 Aug 2017 05:53:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dmCxL-0006r8-CP for pgsql-performance@postgresql.org; Mon, 28 Aug 2017 05:51:27 +0000 Received: from mail-it0-x236.google.com ([2607:f8b0:4001:c0b::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dmCxI-0006NE-OW for pgsql-performance@postgresql.org; Mon, 28 Aug 2017 05:51:26 +0000 Received: by mail-it0-x236.google.com with SMTP id o132so12690696itc.1 for ; Sun, 27 Aug 2017 22:51:24 -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=F7pveAkBhMLFNWK4qOXP9AsUJbyvSdkYABtkD8IGzsw=; b=mBt8rCv3p01SzFXqb9MV6JSgkg4OGiUsGvgDDXp7duHErLiPe7tT1Ef/gxrWiFQgX2 1bnb/OwY5ygsguuKo9+aBvDXlFnEW1ZfHVSTbzKKmiovIqhYSC3HggFD8ZCokmdV1hxb 44qeu0eczYASNU3kkq2DfJMRmzhr3agqZFFarqW4hebcFGkN6bkuzNGzJ/SYcKoE2X6B ZmvaYHbLeDkuXaqDtKg5b534SvRr0pozCscF8Do7ERt7cAzx+qcG8Q2cTbl/5UL9H/ad 94ujtb0GYbS8s0TIg2JKhTIxlfoMO8O16+2MMGoAGYTaD5xeANqkd+qSSOtsOGxeeyiv pROw== 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=F7pveAkBhMLFNWK4qOXP9AsUJbyvSdkYABtkD8IGzsw=; b=IP6Qr5ioR5zKkGcRuZEsLtgcPRro5VObWZqcrzXzjRWFuxDJDj3LanBtNksr1U+j0o /qzvPmtE/8/5iDqmYO0yESY8oUq6BHjItb/k5qBWaBchBlG/30pEmu6aWu3/KRlQB5+o TPoZuRPN5xWh145RoO9XzdGL5cNUEBpcQo3egii9ni2HxZtve+Bt63u1n+auLbel84NU YoIEw6jztairgLhmSMg9sIUdQmcUHNnYDp/Mc37tmFIF0sEdx7aCNxeExuA38PRXm3MU P480BOYdHc+Nc+/c6tr1n2JlOj41/qVeK59lyN6wKADoWAl+y7iqJwZ0xuzmLk+v4xEs 5VgA== X-Gm-Message-State: AHYfb5hGqbklcDEbElBnVDnIzJRL3otr3rUiWQ0hC4fq1d5EJ1sGeB+g zjv6gYnI0ElFmAhfvfZDGUf/bcxjLw== X-Received: by 10.36.162.13 with SMTP id j13mr4694282itf.162.1503899483695; Sun, 27 Aug 2017 22:51:23 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.40.213 with HTTP; Sun, 27 Aug 2017 22:51:22 -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:51:22 -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 ); > > > dbch=# alter foreign table tc_sub_rate_ver_prod OPTIONS (SET prefetch > '10240'); > ERROR: option "prefetch" not found Oh, sorry, I hadn't seen this until I hit send. Unless the documentation is inaccurate or you're using a really old version (from the changelog that option is from 2016), that should work. I don't have enough experience with oracle_fdw to help there, most of my dealings have been with postgres_fdw. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance