Michael Paquier writes:
> On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan wrote:
>> What exactly would be the point? Indexes are automatically maintained by
>> postgres. Something that isn't doesn't seem to me to qualify for the
>> description of "index".
> Perhaps an index without data that cou
Andres Freund wrote:
> the matview patch (0002)
This is definitely needed as a bug fix. Will adjust comments and
commit, back-patched to 9.3.
Thanks for spotting this, and thanks for the fix!
> Also attached is 0004 which just adds a heap_lock() around a
> newly created temporary table in the
Kevin Grittner wrote:
> Laurent Sartran wrote:
>> CREATE MATERIALIZED VIEW t1 AS SELECT text 'foo' AS col1
>> WITH NO DATA;
>> CREATE MATERIALIZED VIEW t2b AS SELECT * FROM t1
>> WHERE col1 = (SELECT LEAST(col1) FROM t1)
>> WITH NO DATA;
>>
>> ERROR: materialized view "t1" has not been
On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan wrote:
> What exactly would be the point? Indexes are automatically maintained by
> postgres. Something that isn't doesn't seem to me to qualify for the
> description of "index".
Perhaps an index without data that could be used by the planner for
aut
On 11/01/2013 02:11 AM, naman.iitb wrote:
Hello
Is there a way by which we can create an empty index on a relation and later
fill it manually by inserting tuples.
I want to know how it can be done in Postgresql code.
Thanks in advance
What exactly would be the point? Indexes are automatic
Hello
Is there a way by which we can create an empty index on a relation and later
fill it manually by inserting tuples.
I want to know how it can be done in Postgresql code.
Thanks in advance
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Creating-Empty-Index-tp5
Teodor Sigaev writes:
> SP-GiST has a bug during creation:
> % create table ranges as select int4range( (random()*5)::int,
> (random()*5)::int+5) as range
> from generate_series(1,100) x;
> % create index ranges_range_spgist_idx on ranges using spgist(
This doesn't seem right:
$ pg_ctl -D /nowhere status
pg_ctl: no server running
It does exit with status 3, so it's not all that broken, but I think the
error message could be more accurate.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscrip
Jim Nasby writes:
> On Nov 1, 2013, at 2:08 PM, Tom Lane wrote:
>> While we could doubtless hack range_out to release those strings again,
>> it seems to me that that's just sticking a finger in the dike. I'm
>> inclined to think that we really ought to solve this class of problems
>> once and f
With gcc 4.8, I get a compiler warning when building the ecpg test
files:
define.pgc: In function 'main':
define.pgc:21:19: warning: typedef 'string' locally defined but not used
[-Wunused-local-typedefs]
typedef char string[NAMELEN];
^
This could be removed, but is it somet
Fabien COELHO writes:
> However I think that part of this interesting checklist and discussion
> could make it to some "caveat" section about reproducible performance
> measures in pgbench documentation, though?
+1. There's already a section of advice about how to get reproducible
numbers from
Logic of this option is under following.
1. execute cluster command to sort records.
2. execute checkpoint to clear dirty-buffers in shared_buffers.
3. execute sync command to clear dirty-file-caches in OS.
4. waiting 10 seconds for raid cache is until empty .
5. execute checkpoint to
On Fri, Oct 25, 2013 at 8:08 PM, Andres Freund wrote:
> On 2013-10-24 13:51:52 -0700, Josh Berkus wrote:
>
> It entirely depends on your workload. If it happens to be something
> like:
> INSERT INTO table (lots_of_data);
> CHECKPOINT;
> SELECT * FROM TABLE;
>
> i.e. there's a checkpoint between lo
Alvaro Herrera writes:
> Stefan Kaltenbrunner wrote:
>> http://www.postgresql.org/message-id/raw/1381949353.78943.yahoomail...@web162902.mail.bf1.yahoo.com
> I would blame Bruce's MUA, or surrounding configuration, for this
> problem. It looks fine in mine, and as far as I can see, Kevin's
> mes
Atri Sharma writes:
> I understand the reasons for executing SELECT before the sort. But,
> couldnt we get the planner to see the LIMIT part and push the sort
> node above the select node for this specific case?
[ Shrug... ] I don't see the point. If the OP actually cares about the
speed of thi
Stefan Kaltenbrunner wrote:
> On 10/31/2013 07:51 PM, Kevin Grittner wrote:
> > Bruce Momjian wrote:
> >> On Wed, Oct 16, 2013 at 11:49:13AM -0700, Kevin Grittner wrote:
> >
> >>> Bruce Momjian wrote:
> >> Would you please send the file as ASCII, e.g. not:
> >>
> >>
> >> default:
> >
> > Huh
On Sat, Nov 2, 2013 at 2:27 PM, Tom Lane wrote:
> David Rowley writes:
> > Tom commited some changes to appendStringInfoVA a few weeks ago which
> > allows it to return the required buffer size if the current buffer is not
> > big enough.
>
> > On looking at appendPQExpBufferVA I'm thinking it w
On Sat, Nov 2, 2013 at 2:00 AM, Tom Lane wrote:
> Jim Nasby writes:
>> On Oct 31, 2013, at 11:04 AM, Joe Love wrote:
>>> In postgres 9.2 I have a function that is relatively expensive. When I
>>> write a query such as:
>>>
>>> select expensive_function(o.id),o.* from offeirng o where valid='Y'
On 29 October 2013 16:10, Peter Geoghegan wrote:
> On Tue, Oct 29, 2013 at 7:53 AM, Leonardo Francalanci
> wrote:
>> I don't see much interest in insert-efficient indexes.
>
> Presumably someone will get around to implementing a btree index
> insertion buffer one day. I think that would be a par
On 10/31/2013 07:51 PM, Kevin Grittner wrote:
> Bruce Momjian wrote:
>> On Wed, Oct 16, 2013 at 11:49:13AM -0700, Kevin Grittner wrote:
>
>>> Bruce Momjian wrote:
>>>
I am seeing this compiler warning in git head:
rowtypes.c: In function 'record_image_cmp':
rowtypes
20 matches
Mail list logo
