On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner <
kevin.gritt...@wicourts.gov> wrote:
> Viktor Bojovi* wrote:
>
> > i don't know why it doesn't use index scan.
>
> Because it thinks your query will return 81226 rows. We need more
> information to make many suggestions beyond "make sure the table
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Viktor Bojovic
Sent: Wednesday, August 31, 2011 5:27 PM
To: pgsql-...@postgresql.org; pgsql-admin@postgresql.org
Subject: [SQL] function based index problem
Hi,
on table entry (17M records) there is on
Viktor Bojovi* wrote:
> i don't know why it doesn't use index scan.
Because it thinks your query will return 81226 rows. We need more
information to make many suggestions beyond "make sure the table has
been analyzed".
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Also, it's not consi
"Campbell, Lance" wrote:
> From: Kevin Grittner [kevin.gritt...@wicourts.gov]
>> Can you get a core file from psql?
> I don't know how to get a core dump. What do I do?
If running this shows a limit (especially zero):
ulimit -c
then run this in your shell before running psql:
ulimit -
When I did the command:
yum info readline
I got the following back:
Installed Packages
Name: readline
Arch: i686
Version : 6.0
Release : 3.el6
Size: 386 k
Repo: installed
From repo : rhel-x86_64-workstation-6
Summary : A library for editing typed com
Hi,
on table entry (17M records) there is one index:
CREATE INDEX ndxlen
ON uniprot_frekvencije.entry
USING btree
(length(sequence::text));
When using ">=" in search which returns only two records, query runs much
(hundred times) slower. i don't know why it doesn't use index scan. I just
wa
Kevin,
The postgres log just shows lines like this:
2011-08-31 16:22:17 CDT LOG: unexpected EOF on client connection
I don't know how to get a core dump. What do I do?
Thanks,
Lance
From: Kevin Grittner [kevin.gritt...@wicourts.gov]
Sent: Wednesday, Au
"Campbell, Lance" wrote:
> From: Kevin Grittner [kevin.gritt...@wicourts.gov]
> Did you check for a "~/.psqlrc" file?
> I just checked and the below file does not exist. I recreated the
> problem then checked again. No such file.
Is anything showing in the server log?
Can you get a core
Which version of libreadline you have installed?
--
pasman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I just checked and the below file does not exist. I recreated the problem then
checked again. No such file.
Lance
From: Kevin Grittner [kevin.gritt...@wicourts.gov]
Sent: Wednesday, August 31, 2011 11:59 AM
To: Campbell, Lance; pgsql-admin@postgresql.org
"Campbell, Lance" wrote:
> Postgres 9.0.4
> I installed from the visual linux installer
> Redhat 6 newest updates
>
> I keep getting the following message when logging into the command
psql:
>
> psql (9.0.4)
> Type "help" for help.
>
> Segmentation fault (core dumped)
>
>
> It then kicks me o
Postgres 9.0.4
I installed from the visual linux installer
Redhat 6 newest updates
I keep getting the following message when logging into the command psql:
psql (9.0.4)
Type "help" for help.
Segmentation fault (core dumped)
It then kicks me out. I uninstalled the application completely even d
sorry, found http://pgfoundry.org/mail/?group_id=155 pgfoundry.org
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgpool-II-forum-tp4754155p4754163.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgs
Hi!
Where can I ask about using pgpool-II (forum, maillist ...)?
Thank you!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgpool-II-forum-tp4754155p4754155.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list
14 matches
Mail list logo
