In response to Philippe Lang :
> Hi,
>
> I'm trying to figure out how to use an index on an immutable function
> call in order to speed up queries.
> My goal is to make query...
>
> select * from indexed_table WHERE data1 >
> this_is_a_long_transformation(data2);
>
> ... as fast as
>
> sele
In response to Yan Cheng Cheok :
> By referring to
> http://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-SQL-TABLE-FUNCTIONS,
> section 34.4.8. SQL Functions Returning TABLE
That's for language SQL, you are using:
> CREATE OR REPLACE FUNCTION get_measurements(IN bigint)
> LANGU
I'd like to extend full text search so that I can transform tvectors
in tquery and have direct access to a tvector as a record/array.
I'm on Debian.
This is my first experience with pg source code.
I'd appreciate any pointer that will quickly put me on the right
track.
thanks
--
Ivan Sergio Bo
Hi,
I'm trying to figure out how to use an index on an immutable function
call in order to speed up queries.
I came up with this small test:
--create database foo;
--drop table indexed_table;
create table indexed_table (
id serial primary key,
data1
By referring to
http://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-SQL-TABLE-FUNCTIONS,
section 34.4.8. SQL Functions Returning TABLE
I create the following stored procedures.
-- Function: get_measurements(bigint)
-- DROP FUNCTION get_measurements(bigint);
CREATE OR REPLACE FU
Having 'external tables' lets us avoid the step of loading data from a
file into the table. We do not have to check whether a load job has run
successfully, whether the data in the table really corresponds to the data
in the file etc. It also lets us decide how many rejects can be allowed
and s
Terry wrote:
Hello,
Sorry for the poor subject. Not sure how to describe what I need
here. I have an application that logs to a single table in pgsql.
In order for me to get into our log management, I need to dump it out
to a file on a periodic basis to get new logs. I am not sure how to
tack
On Tue, Jan 19, 2010 at 06:35:10PM +1300, Andrej wrote:
> 2010/1/19 Bret S. Lambert :
>
> > Isn't this just over-engineering? Why not let the database do
> > the work, and add the column with a default value of 0, so that
> > you don't have to modify whatever 3rd-party app dumps the data:
>
> But
2010/1/19 Bret S. Lambert :
> Isn't this just over-engineering? Why not let the database do
> the work, and add the column with a default value of 0, so that
> you don't have to modify whatever 3rd-party app dumps the data:
But what if his third-party software does something silly like a "select
On Mon, Jan 18, 2010 at 05:49:32PM -0600, Terry wrote:
> On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote:
> > On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
> >> On 1/18/2010 4:08 PM, Terry wrote:
> >>>
> >>> Hello,
> >>>
> >>> Sorry for the poor subject. ?Not sure how to describe what I need
>
On 19/01/2010 1:13 AM, Vincenzo Romano wrote:
Another case, Tom, could be when the file is updated from a non-DB
application and you need to synchronize
the data with other DB applications ...
How can that work without a transactional file system, though? If the
external process writes to the
On Mon, Jan 18, 2010 at 6:35 PM, Scott Marlowe wrote:
> On Mon, Jan 18, 2010 at 12:28 AM, Martijn van Oosterhout
> wrote:
>> On Fri, Jan 15, 2010 at 08:41:38AM -0700, Scott Marlowe wrote:
>>> With slony 2.0.3 or so, I had occasional complete lockups of my
>>> database that I didn't have time to t
On Mon, Jan 18, 2010 at 6:35 PM, Scott Marlowe wrote:
> You could have used create index interactively.
s/interactively/concurrently/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jan 18, 2010 at 12:28 AM, Martijn van Oosterhout
wrote:
> On Fri, Jan 15, 2010 at 08:41:38AM -0700, Scott Marlowe wrote:
>> With slony 2.0.3 or so, I had occasional complete lockups of my
>> database that I didn't have time to troubleshoot as it was a live
>> cluster and I had to restart s
On Mon, Jan 18, 2010 at 12:43 PM, Vick Khera wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
>> Does this max_fsm_pages value seem OK for a 46GB database?
>> I've clustered all the tables that seemed to be exhibiting large amounts
>> of bloat.
>
> My big DB is about 70 on disk. I
On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote:
> On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
>> On 1/18/2010 4:08 PM, Terry wrote:
>>>
>>> Hello,
>>>
>>> Sorry for the poor subject. Not sure how to describe what I need
>>> here. I have an application that logs to a single table in pgsql.
On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
> On 1/18/2010 4:08 PM, Terry wrote:
>>
>> Hello,
>>
>> Sorry for the poor subject. Not sure how to describe what I need
>> here. I have an application that logs to a single table in pgsql.
>> In order for me to get into our log management, I n
On 1/18/2010 4:08 PM, Terry wrote:
Hello,
Sorry for the poor subject. Not sure how to describe what I need
here. I have an application that logs to a single table in pgsql.
In order for me to get into our log management, I need to dump it out
to a file on a periodic basis to get new logs. I a
Greg Stark a écrit :
> On Mon, Jan 18, 2010 at 8:24 PM, Jean-Yves F. Barbier <12u...@gmail.com>
> wrote:
>> I've got to store many small videos; to make things simple (backup/restore,
>> because users don't know very much about IT) I've choosen BYTEA + EXTERNAL,
>> is it the right choice?
>
> If
Hello,
Sorry for the poor subject. Not sure how to describe what I need
here. I have an application that logs to a single table in pgsql.
In order for me to get into our log management, I need to dump it out
to a file on a periodic basis to get new logs. I am not sure how to
tackle this. I tho
On Mon, Jan 18, 2010 at 8:24 PM, Jean-Yves F. Barbier <12u...@gmail.com> wrote:
> I've got to store many small videos; to make things simple (backup/restore,
> because users don't know very much about IT) I've choosen BYTEA + EXTERNAL,
> is it the right choice?
If you want to store them in the dat
Hi list,
I've got to store many small videos; to make things simple (backup/restore,
because users don't know very much about IT) I've choosen BYTEA + EXTERNAL,
is it the right choice?
JY
--
Wait for that wisest of all counselors, Time.
-- Pericles
--
Sent via pgsql-general mailing list (pgsql
On Monday 18 January 2010 11:31:57 am Bob Pawley wrote:
> Hi
>
> I have a table that has one column (pump1) controlled by a dbcheckbox. The
> values can be True, False or null.
>
> I want to insert a row of values into second table when column pump1 value
> is 'True'. I don't want the trigger to in
Chris Barnes wrote on 18.01.2010 21:05:
I would like to move a table that is used to store images from mysql to
postgres. The only stumbling I may encounter, may be switching from
mysql blob to something in postgres.
We store chart images in a mysql medium blob type.
How can I store these in
I would like to move a table that is used to store images from mysql to
postgres. The only stumbling I may encounter, may be switching from mysql blob
to something in postgres.
We store chart images in a mysql medium blob type.
How can I store these in postgres?
Chris
| IMA
On Mon, Jan 18, 2010 at 02:43:11PM -0500, Vick Khera wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
> > Does this max_fsm_pages value seem OK for a 46GB database?
> > I've clustered all the tables that seemed to be exhibiting large amounts
> > of bloat.
>
>
> One more thing you m
On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
> Does this max_fsm_pages value seem OK for a 46GB database?
> I've clustered all the tables that seemed to be exhibiting large amounts
> of bloat.
My big DB is about 70 on disk. I have fsm pages set to 3.4 million,
and occasionally that gets
Hi
I have a table that has one column (pump1) controlled by a dbcheckbox. The
values can be True, False or null.
I want to insert a row of values into second table when column pump1 value is
'True'. I don't want the trigger to insert a row when other columns of the
first table are updated or w
Hi guys,
I'm working with full-text search on my project, however i'm receiving an
"Config file error: 7 ERROR: no tsearch config CONTEXT" message but i don't
know what it means.
The entire error message received is:
"SQLSTATE[F]: Config file error: 7 ERROR: no tsearch config CONTEXT: SQL
st
Does this max_fsm_pages value seem OK for a 46GB database?
I've clustered all the tables that seemed to be exhibiting large amounts
of bloat.
reporting=# SELECT pg_size_pretty(pg_database_size('reporting'));
pg_size_pretty
46 GB
(1 row)
NOTICE: number of page slots needed
Very interesting discussion indeed.
It seems that "Postgresql:The world's most advanced open source database" can
not work properly on "Mac OS X: the world's most advanced operating system" and
FreeBSD.
Don't you think postgresql.org should remove from their download page the links
to FreeBSD
2010/1/18 Tom Lane :
> Greg Smith writes:
>> Craig Ringer wrote:
>>> For those non-Oracle users among us, what's an external table?
>
>> External tables let you map a text file directly to a table without
>> explicitly loading it. In PostgreSQL, if you have data in a CSV file,
>> usually you'd im
Tom Lane wrote:
I'm finding it hard to visualize a use-case for that. We must postulate
that the table is so big that you don't want to import it, and yet you
don't feel a need to have any index on it. Which among other things
implies that every query will seqscan the whole table. Where's the
On Mon, Jan 18, 2010 at 7:57 AM, Tom Lane wrote:
> Greg Smith writes:
>> Craig Ringer wrote:
>>> For those non-Oracle users among us, what's an external table?
>
>> External tables let you map a text file directly to a table without
>> explicitly loading it. In PostgreSQL, if you have data in a
Hola
Me gustaría saber si es posible devolver el tamaño de un campo de una
determinada tabla. Es decir, si yo defino por ejemplo un campo de tipo
character varying (8), sería posible devolver el número 8?? o en su defecto
el número de bytes máximo de ese campo??
Saludos
On Mon, Jan 18, 2010 at 2:57 PM, Tom Lane wrote:
> I'm finding it hard to visualize a use-case for that. We must postulate
> that the table is so big that you don't want to import it, and yet you
> don't feel a need to have any index on it. Which among other things
> implies that every query wil
On Mon, Jan 18, 2010 at 09:57:02AM -0500, Tom Lane wrote:
> Greg Smith writes:
> > Craig Ringer wrote:
> >> For those non-Oracle users among us, what's an external table?
>
> > External tables let you map a text file directly to a table without
> > explicitly loading it. In PostgreSQL, if you h
Greg Smith writes:
> Craig Ringer wrote:
>> For those non-Oracle users among us, what's an external table?
> External tables let you map a text file directly to a table without
> explicitly loading it. In PostgreSQL, if you have data in a CSV file,
> usually you'd import it with COPY before yo
Craig Ringer wrote:
For those non-Oracle users among us, what's an external table?
External tables let you map a text file directly to a table without
explicitly loading it. In PostgreSQL, if you have data in a CSV file,
usually you'd import it with COPY before you'd use it. If external
ta
Great, thank you!
I assume this one goes into 8.4.3, right?
Yeah, or apply patch
http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gin/ginscan.c?r1=1.25&r2=1.26
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Great, thank you!
I assume this one goes into 8.4.3, right?
2010/1/18 Teodor Sigaev
> Basically, I started testing prefix matching in FTS and got into
>> troubles. Self-contained example follows:
>>
>
> Thank you, fixed. The reason was in incorrect optimization of GIN scan: GIN
> reuses scan res
Basically, I started testing prefix matching in FTS and got into
troubles. Self-contained example follows:
Thank you, fixed. The reason was in incorrect optimization of GIN scan: GIN
reuses scan result for equals key, but comparison of key didn't take into
account a difference of scan's strate
I was testing the ispell text search dictionary and it appears to be behaving as
if the ispell option "allaffixes" was set to "on". This wasn't the case for the
original tsearch2 contrib module, and for the ispell program itself which
defaults to "off".
So for example, if I create a simple Di
Hi All,
We decide add support PostgreSQL database (now supporting only Oracle
database) to our product.
In Oracle we mapping Java BigDecimal to number(19, 2), in PostgreSQL to
numeric(19, 2).
If I store to "BigDecimal column" number without decimal, e.g. "3", than
Oracle JDBC driver return
44 matches
Mail list logo
