5-6 seconds is a lot of time for the query and dataset size you mentioned. Did you check the profile to see where the time is being spent?
On Tue, May 30, 2017 at 2:53 AM, <jasbir.s...@accenture.com> wrote: > Hi, > > I am creating an UNLOGGED table in PostgreSQL and reading it using Apache > Drill. Table contains just one column with 1000 UUID entries. > It is taking 5-6 secs for me to read those records. > > I am fetching data using below query, > > Select uuidColumn from pgPlugin.public.uuidTable > > > Is there anything that I am missing or any Drill level tweaking is > required so that queries can be executed in milli-seconds. > > Thanks in advance. > > Regards, > Jasbir singh > > ________________________________ > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise confidential information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the e-mail by you is prohibited. Where allowed > by local law, electronic communications with Accenture and its affiliates, > including e-mail and instant messaging (including content), may be scanned > by our systems for the purposes of information security and assessment of > internal compliance with Accenture policy. > ____________________________________________________________ > __________________________ > > www.accenture.com >
